Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|