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