Returning a value from a range

[Josh M.]

I'm trying to create this attached bonus calculation sheet and I'
baffled on how to create a cleaner more simple formula that a hug
nested IF function. I don't know where to go from here. I need to b
able to enter a percentage into the yellow box and have the red bo
return the bonus amount based on whichever range the percentage fall
into

+-------------------------------------------------------------------
|Filename: Excel Pic.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=806
+-------------------------------------------------------------------

 

[lhkittle]

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|

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

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

Regards,
Howard