Hi
The syntax for IF function is:
=IF(ConditionIsTrue, FirstValue, SecondValue)
i.e. there are 3 arguments for IF function.
Your second formula is:
=IF(ConditionIsTrue, FirstValue, SecondValue, ThirdValue)
where ThirdValue is returned by IF function with omitted 3rd argument (when
condition is false, FALSE is returned):
IF(AnotherConditionIsTrue, ThirdValue)
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"peopleschampion" wrote in
message ...
If I enter =IF(F9<0,F9,IF((F9-G9)<0,0,(F9-G9))) into Excel 97 the formula
works fine. If I
enter =IF((F9-G9)<0,0,(F9-G9),if(F9<0,F9)), which to me looks effectively
the same, I get an
error message saying I have entered too many arguments for this function.
Have I got the
brackets wrong or is there some other reason why the second version
doesn't work?
Bryan
|