I need to calculate a salary formala for the following and can only find a
formula for two variables. I have been successful getting the formula to
calcuate the values if the Advisor is equal to or above region, but I can't
get it to calculate if the Advisor is below region to enter 0.0%. I am
trying to complete a salary spreadsheet to put in the three region
percentages below (2.0, 1.0, 0.0). Here is the formula i am using...
=IF(B5>B6,B27,B26)
I need to be able to enter cell b25 if b5 is less than b6. Can anyone
assist with this, please?
Advisor 92.5% (cell b5)
Region 89.4% (cell b6)
Below Region 0.0% (cell b25)
Equal to Region 1.0% (cell b26)
Above Region 2.0% (cell b27)
Thank you for your help!
Bookmarks