Please Help!!!

[ADW1587]

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 G3>10 but <24, then I need H3=G3xC3. and finally, if G3>24 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!!!

 

[RagDyeR]

You didn't state what's supposed to happen if G3 *exactly* equals 10 and 24.

This will multiply G3 with C3 for those two cases:

=IF(G3>24,G3*D3,IF(G3<10,G3*B3,G3*C3))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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 G3>10 but <24, then I need H3=G3xC3. and finally, if G3>24 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!!!

 

[Don Guillett]

try
=IF(G3<=10,B3,IF(G3>10,C3,IF(G3>24,D3)))*G3