Please Help!!!
 

I am trying to find a function to solve my problem. I'm not really sure if
there even is one. Pretty much what I need is if G3 <10, then I need H3 to
=G3xB3. If G310 but <24, then I need H3=G3xC3. and finally, if G324 then
H3=G3xD3. I'm not even sure if this makes sense to anyone but me, I'm
obviously no math whiz and even worse at excel so please help me if at all
possible!!!

Please Help!!!
 

try
=IF(G3<=10,B3,IF(G310,C3,IF(G324,D3)))*G3

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ADW1587" wrote in message
...
I am trying to find a function to solve my problem. I'm not really sure if
there even is one. Pretty much what I need is if G3 <10, then I need H3 to
=G3xB3. If G310 but <24, then I need H3=G3xC3. and finally, if G324 then
H3=G3xD3. I'm not even sure if this makes sense to anyone but me, I'm
obviously no math whiz and even worse at excel so please help me if at all
possible!!!