Please Help!!!

  • Thread starter Thread starter ADW1587
  • Start date Start date
A

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!!!
 
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!!!
 
Back
Top