Need help on an excel formula.
Basically I want to take the number in B2 if that number is between 1000-1499 then *.06, if the number is between 1500-1999 then *.1, if the number is between 2000-2999 then *.12, if number is between 3000-3999 then *.13, if number is over 4000 then * .15.
Tried doing a nested IF Function but I can only get it to do the .06 calculation.
I do not have much experience with excel.
Solved by M. H. in 26 mins