Returning a value from a range
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.
|