IF statement
 

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

=IF(L40,IF(L5<=Assumptions!$F$15,Assumptions!$D$4 9,Assumptions!$D$50))

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

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)


"Joe" wrote in message
...
Does anyone know if this is this a legitimate IF statement?

=IF(L40,IF(L5<=Assumptions!$F$15,Assumptions!$D$4 9,Assumptions!$D$50))

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

It looks pretty ok. Missing a False statement for L40, 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


"Joe" skrev i melding
...
Does anyone know if this is this a legitimate IF statement?

=IF(L40,IF(L5<=Assumptions!$F$15,Assumptions!$D$4 9,Assumptions!$D$50))

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