Thread: IF statement
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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?