For this type of problem, you can either use a bunch of IF statements, or
use a lookup function similar to this;

=A1*LOOKUP(299,{0,2;300,3;500,55})

The 0,2 or 300,3 or 500,55 indicate the "lookup range" and the "returned
value".

The 0 is the low end of the range (could be negative if you want) and 500 is
the minimum cutoff to return 55.

You would substitute ranges 800, 2401, and so on. The 299 in the above
example is the number to be looked up.




"Nanci" wrote in message
...
How (or can) I enter a formula that would do the following:

if G6 is C46 and <E46 then multiply by G46, but if G6 is C48 and <E48
then multiply by G48. I have five sets of ranges to include and five
different amounts to multiply by based on the number in G6. Example, if
G6
is between 800 and 2400 then multiply it by .254, if it's between 2401 and
5000 then multiply it by .234 and so on.

Thanks!
--
Nanci