Conditional Statement Formula needed

Topic

New Reply

Hi,

I need to put enter in a conditional formula in excel. The formula is based on whether or not the value in F14 is negative or not I have:

=IIF(F14<1,(F14+F11),(F11-F14))

I get a ?Name error with it. I've tried enclosing F14 in "" and well as [] but nothing works. What am I missing?

Thanks,
Leesha

Reply | Quote

Replies

IIf is a VBA function (also used in Access). The equivalent worksheet function in Excel is IF.
You don’t need parentheses around the if-true and if-false parts:

=IF(F14<1,F14+F11,F11-F14)

Reply | Quote

Thanks Hans! Worked perfectly!

Reply | Quote