Hi

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

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

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

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

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


Arvi Laanemets


"Sal" wrote in message
...
I always get muddled with quotation marks so can somebody please expalin
this
formula.

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