On Monday, March 11, 2013 7:08:22 PM UTC-7, Josh M. wrote:
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.





+-------------------------------------------------------------------+

|Filename: Excel Pic.jpg |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=806|

+-------------------------------------------------------------------+







--

Josh M.

In C2 try =VLOOKUP(C1,B5:C15,2)

Regards,
Howard