IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to avoid nested IFs 8
Nesting IF/OR Statement 14
Using IF statements in conjunction with other function 1
Array of Labels 4
Wow, never seen this error before (Excel science experiment) 3
Rounding up to a multiple of 12 1
Conflicting results in formulas? 4
What-If Analysis 1

Back
Top