Understanding this formula

[Sal]

I always get muddled with quotation marks so can somebody please expalin this
formula.

=IF(F86>0,IF(E86="",F86*40*40*10,E86*40*10),0)
Thank you very much.
S

 

[Arvi Laanemets]

Hi

The returned value is:
If F86>0 And E86="" Then F86*16000
Else If F86>0 Then E86*4000
Else 0

Btw. you can simplify the formula
=IF(F86>0,IF(E86="",40*F86,E86)*400,0)

.... or
=(F86>0)*IF(E86="",40*F86,E86)*400

.... it depends on values in cells F86 and E86, maybe this formula will do
too
=IF(F86>0,MAX(40*F86,E86)*400),0)

.... or even
=(F86>0)*MAX(40*F86,E86)*400)


Arvi Laanemets

 

[Sal]

Hi
Thank you for your very quick response - I will try the other options out.
I still don't know where to "" marks fit into this formulas!
Regards.
Sal

 

[Alan]

It means that if cell E86 is empty ("") then do something, if cell E86 is
not empty then do something else, that is to say it's testing whether E86 is
blank or not.
Regards

 

[Sal]

Thank you for that - much appreciated.
Sal

-----Original Message-----
It means that if cell E86 is empty ("") then do something, if cell E86 is
not empty then do something else, that is to say it's testing whether E86 is
blank or not.
Regards



.