I tried this but not working:
=IF(F6<=13,F6*13.10,IF(F6<=32,F6*14.13),IF(F6<=52, F6*14.99),IF(F6<=70,F6*16.16),IF(F6<=90,F6*16.74), IF(F6<=100,F6*19.67)).
I think it's because lets say the number was 16 - that means it matches ALL
the rest of the IF's right? So that won't work. Any ideas?

"newby1273" wrote:

Here is what I want to do:
If a cell (formatted as number) is between 0 and 10 multiply it by this. If
it's between 10 and 20 multiply it by that. How do you write that?

thx