Formulas

[joaniemic]

I need help with 2 formulas:

The first
IF E39<600 E44 is the sum of E39 + E43 AND if E39 is equal to or greater
than 600 then E44 is zero.

Second
IF E39 is =>600 E49 is the sum of e39+E39 x .08 AND if E39 is <600 E49 is
zero.

Thank you!

 

[FSt1]

hi
1. in E44 put....
=if(e39<600,e39+e43,0)

2. in e44 put...
are you sure you typed your requirement correctly???
=if(339<600,0,(E39*2)*.08)

post back if 2 above is incorrect.

Regards
FSt1

 

[David Biddulph]

It looked as if the OP was asking for E39*1.08, not E39*2*0.08, but of
course your guess is as good as mine.
If my guess is right, the formula in E49 is =if(E39<600,0,E39*1.08) [You
had a typo or two, as well as a different interpretation.]

 

[FSt1]

hi
you are right about the typos. thanks for catching that. as to the
interpertation....
i looked at that several times. i even asked if it was correct. so there is
some ambiguity there. the op will have to clairfy.

Regards
FSt1

It looked as if the OP was asking for E39*1.08, not E39*2*0.08, but of
course your guess is as good as mine.
If my guess is right, the formula in E49 is =if(E39<600,0,E39*1.08) [You
had a typo or two, as well as a different interpretation.]
--
David Biddulph

hi
1. in E44 put....
=if(e39<600,e39+e43,0)

2. in e44 put...
are you sure you typed your requirement correctly???
=if(339<600,0,(E39*2)*.08)

post back if 2 above is incorrect.

Regards
FSt1