Thread: code:IF statement

Hi everyone,

I want to use the IF statement - IF(logical_test, [value_if_true], [value_if_false]) - with a formula in 'the value if true' segment, is this possible? I can use it with a text result but can't get it to work with a formula. The formula would be to subtract one range from another and post the result if the logical test is true with a null if false.
I really don't have enough hair left to keep trying on my own.
Thanks

Hi and thanks for the welcome! Sorry, I should have posted the formula; this is it -

=SUM($E$2:E4)-(SUM($C$2:C4))

It works fine by itself, I just want to wrap the IF statement around it.

You haven't said what the logical test portion is but try this:

=IF(logical test,SUM($E$2:E4)-SUM($C$2:C4),"")

Hi Cutter,
looks so simple now, I was confused with the square brackets and I may have missed a comma. Strange how I can see other people's errors but not my own.
Thanks.