Forum 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??
—–
Melanie

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

    10/4/17 @ 3:22 pm

    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:

    =IF(T2,D2+R2,R2)

    Melanie
    10/4/17 @ 3:26 pm

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

Leave a New Comment Related to "Checkboxes- Formula If Its Not Checked"

:

:

:


0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)