Hi Josh M
Use the VLOOKUP with how the data you already have in place.
In cell C2: =VLOOKUP(C1,A5:C15,3,1)
You do not need the data in B5:B15
Have a look at this link for VLOOKUP.
http://www.myonlinetraininghub.com/?s=VLOOKUP
Kevin
Quote:
Originally Posted by Josh M.
I'm trying to create this attached bonus calculation sheet and I'm baffled on how to create a cleaner more simple formula that a huge nested IF function. I don't know where to go from here. I need to be able to enter a percentage into the yellow box and have the red box return the bonus amount based on whichever range the percentage falls into.
|