Thread: Please Help!!!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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!!!