Hi, this may be very obvious however I have spent the last 30 minutes trying to figure it out with no luck.
In Cell D4, this will have a manually input figure of any where between 0%-200%
I'm trying to make Cell E4 formulate based on the assumptions below.
Less then 98% = 0
Between 98%-100% = 48
Between 100%-110% = 60
Over 110% = 72
Can anyone assist with the formula, I just cannot get this to work?
Appreciate any assistance!
It will depend ENTIRELY on how exactly the percentages are represented in D4: is this a number formatted as a percentage, or is it text?
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi there,
Thanks for the response, hoping to have it formatted in a Percentage, albeit I can adapt if it wont work.
I've attached the workbook, with a desired outcome table to better represent what I'm looking for.
Greatly appreciate your assistance.
You need to make the table look like this:
Excel 2016 (Windows) 32 bit
Sheet: Sheet1
Then in D5, use this:
=VLOOKUP(C5,$F$8:$G$11,2,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks