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.05I'm a "rookie", so any help is greatly appreciated.

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

andgreater 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.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History