Hi, i am trying to solve this all morning, any help is appreciated:
I have three conditions:
from 1 to 12000
from 12001 to 34999
from 35000 and above
And i am trying to tell excel that
IF the cell O35 is 1 to 12000 then 15% IF the cell O35 is from 12001 to 34999 then 35% IF the cell O35 is greater than 35000 then 45%
or to say it another way
IF the cell O35 is greater than 1 but less than 12000 then 15% IF the cell O35 is greater than 12001 but less than 34999 then 35% IF the cell O35 is greater than 35000 then 45%
But i fail miserably!!! This is for tax purposes! Can someone kindly assist?
Bookmarks