MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Checkboxes- Formula If Its Not Checked

I want my formula to work like this:
If I have the checkbox checked, I want it to add D2 and R2. IF(T2,D2+R2) This is working perfectly!!

However, if the checkbox is NOT checked, I want it to only put R2 in the cell.

How do I make that part of the formula??

Comments: 2 Responses to “Checkboxes- Formula If Its Not Checked”

    6 years ago

    I assume you mean in Numbers?

    If you look at the help for the IF function, you'll see that the first parameter is the condition, the second is the value if true, and the third is the value if false. So your formula would simply be:


    6 years ago

    Thank you so much for the quick response! Your video was so helpful... best I found online! Thank you again!

Comments Closed.