Understanding this formula
 

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

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

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

"Arvi Laanemets" wrote:

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

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" wrote in message
...
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

"Arvi Laanemets" wrote:

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

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
"Sal" wrote in message
news:D42A9488-B09E-4D11-BF19-
...
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

"Arvi Laanemets" wrote:

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
news:BFFDA756-594D-4DE2-B602-
...
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





.