Solved Excel Less then and more then

April 12, 2017 at 09:08:09
Specs: Windows 10
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.


See More: Excel Less then and more then

Report •

#1
April 12, 2017 at 09:13:57
✔ Best Answer
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.


Report •

#2
April 12, 2017 at 09:16:26
perfect thank you so much

Report •
Related Solutions


Ask Question