Hi Nanci

=IF(AND(G6C46,G6<E46),G6*G46,IF(AND(G6C48,G6<E48 ),G6*G48,0))
you can put more IF statements in where the 0 is using the following
structure
=IF(AND(Test1,test2),TRUE,IF(AND(test1,test2),TRUE ,IF(AND(test1,test2),TRUE,IF(AND(test1,test2),TRUE ,IF(And(test1,test2),TRUE,FALSE)))))

Cheers
JulieD

"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