Hi,
I am trying to create a formula which takes a percentage in a cell, checks this in a percentage range (0-89, 90-94, 95-100) and depending on which range it is there is a different calculation applied (0-89% = 10%*£100, 90-94% = 5%*£100, 95-100% = 1%*£100)
Please can someone advise the best way forward.
Thanks
GM
Last edited by GingerMike; 07-18-2014 at 09:20 AM.
Try
=LOOKUP(A1,{0,0.9,0.95},{"None",5,10})
Life's a spreadsheet, Excel!
Say thanks, Click *
Something like this...
A1 = some %
=IF(A1="","",IF(A1>=0.95,"None",IF(A1>=0.9,0.05,0.1)))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Tony,
This looks like a good basis, if I wanted to use the specifics of the calculation in the formula how would that change it?
For example if the percentage is 90% it returns the answer to 5% of £100, instead can I use the cell references in the formula for example 5% is in cell B1 and £100 is in Cell B2 and so on....
THANK YOU!!
If I understand, like this....
=IF(B1="","",IF(B1>=0.95,"None",B2*IF(B1>=0.9,0.05,0.1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks