IF statement

J

Joe

Does anyone know if this is this a legitimate IF statement?

=IF(L4>0,IF(L5<=Assumptions!$F$15,Assumptions!$D$49,Assumptions!$D$50))

If it's not, will it still return a result?
 
B

Bob Phillips

It is not well-formed in that there is no action if L4 is not >0, but it is
'legitimate'.

It will return a result, but of FALSE if L4<=0

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
H

Harald Staff

It looks pretty ok. Missing a False statement for L4>0, so it will return a
boolean value if L4 is 0 or less. Why don't you try it and see for yourself
what happens ? Nothing will catch fire because of this, honest.

HTH. Best wishes Harald
 
Top