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
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)
Thank you so much for the quick response! Your video was so helpful... best I found online! Thank you again!