Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 "joaniemic" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 "FSt1" wrote in message ... 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 "joaniemic" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 "David Biddulph" wrote: 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 "FSt1" wrote in message ... 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 "joaniemic" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |