I'm trying to work out a formula where it can do the following if cell if less then 249.99= 1% of the cell amount

If cell is is between 250 to 999.99 = 1.5% of the cell amount

if cell is more then 1000.00 = 2% of cell amount,The cell I'm using is E2 for this example.

Any help would be greatly received.

Try the following Nested IF formula. =IF(E2>999.99,E2*2%,IF(E2>249.99,E2*1.5%,E2*1%))

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

perfect thank you so much

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History