I have a value in one table and a checkbox in another. i would like the value to go up by 1 when the box is checked. I want to do something like this:
=IF(C23,B4=B4+1)
but excel throws an error. C23 is the checkbox and B4 is the number. Thanks for the help
I think the best bet is to put a check mark somewhere else in the spreadsheet to refer to. So, for example, lets say you put the checkmark in cell A1. Then, your formula (based on what you put on your post) should be
=if(c23=a1,b4+1,b4)
Now, if B4=3 and C23 has a checkmark, you should see the value 4 in the cell where you input your formula. If there's no checkmark, the cell with the formula will show the value 3.
Originally Posted by SamuelMRoth
This only changes the cell the formula is in not B4. if i put it in B4 it throws a circular error.
Hi skinman ,
you can't put =IF(C23,B4=B4+1) in cell B4, like what you said is circular error.
How can formula add formula itself.
Perhaps how you get the B4's number? If B4 get from another formula from any cell(eg D4), simply let it be =IF(C23,D4+1,D4)
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Check Marks.xlsx
Hello Skinman,
I've attached a little file I put together that I think accomplishes what you're trying to do. Have a look and let me know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks