Need help with subtract if False and add if True function

[Kusaywa]

What I have is this: =IF(F3=FALSE,C2-C3,"")
This subtracts the amount in cell C3 from C2 if FALSE is in cell F3

I want to add to this formula to add the amounts if F3 is TRUE

Just not getting it... Thanks for any help.

 

[Joe4]

You need to nest IF statements, i.e.:

[COLOR=#333333]=IF(F3=FALSE,C2-C3,[/COLOR][COLOR=#333333]IF(F3=TRUE,C2+C3,"")[/COLOR][COLOR=#333333])[/COLOR]

 

[Kusaywa]

Swear I tried that!!! That did it!!! Thanks

 

[Joyner]

Hello, just for the fun of it, if F3 can only be TRUE or FALSE, then:

=CHOOSE(F3+1,C2-C3,C2+C3)

 

[Jonmo1]

If we can assume that F3 will only ever be TRUE or FALSE..

=IF(F3,C2+C3,C2-C3)

 

[Joyner]

If we can assume that F3 will only ever be TRUE or FALSE..

=IF(F3,C2+C3,C2-C3)

Dang, you are right and I used that before but I'm getting rusty

 

[Joe4]

If we can assume that F3 will only ever be TRUE or FALSE..

=IF(F3,C2+C3,C2-C3)

I thought of that, but thought that blank/empty may be too likely a possibility, so thought it is better to be explicit.
Otherwise, if F3 is empty/blank, it will do the subtraction.