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" <Sal@discussions.microsoft.com> wrote in message
news:BFFDA756-594D-4DE2-B602-BB9651962CB7@microsoft.com...
> 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

[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

"Arvi Laanemets" wrote:

> 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" <Sal@discussions.microsoft.com> wrote in message
> news:BFFDA756-594D-4DE2-B602-BB9651962CB7@microsoft.com...
> > 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
>
>
>

[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" <Sal@discussions.microsoft.com> wrote in message
news:D42A9488-B09E-4D11-BF19-1E4F3AE5C973@microsoft.com...
> 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 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" <Sal@discussions.microsoft.com> wrote in message
>> news:BFFDA756-594D-4DE2-B602-BB9651962CB7@microsoft.com...
>> > 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
>>
>>
>>

[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
>"Sal" <Sal@discussions.microsoft.com> wrote in message
>news:D42A9488-B09E-4D11-BF19-
1E4F3AE5C973@microsoft.com...
>> 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 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" <Sal@discussions.microsoft.com> wrote in message
>>> news:BFFDA756-594D-4DE2-B602-
BB9651962CB7@microsoft.com...
>>> > 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
>>>
>>>
>>>
>
>
>.
>