|
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! |
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! |
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! |
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! |
| All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com