I need to create an If statement that will give me a percentage based on a range...
So, if A1 is between 0 and 10 then A2 should be 5%
If A1 is between 10.01 and 12.50 A2 should be 7%
If A1 is between 12.51 and 15.00 A2 should be 9%
If A1 is between 15.01 and higher A2 should be 10%
I could not find the formula that helped in my searches, so I ask you help.
Thanks so much
Bookmarks