Nesting multiple if statements/formula

November 16, 2011 at 12:14:03
Specs: Windows XP
This is what I want the cell to do:

If A1 is less than 100,001 then multiply by 2.05
If A1 is greater than 100,000 but less than 500,001 then multiply by 1.60
If A1 is greater than 500,000 but less than 2,000,000 then multiply by 1.05

I'm a "rookie", so any help is greatly appreciated.

See More: Nesting multiple if statements/formula

Report •

November 16, 2011 at 12:51:01
How are the values being determined? Can you be 100% sure that e.g. values like 100,000.5 won't ever occur?

If it could then that value is less the 100,001 and greater than 100,000 and therefore your conditions can not be met.

Keep in mind that what appears in the cell based on it's formatting may not be the actual value in the cell. The formula will use the actual value, not the formatted value.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question