software

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(B5gt;B6,B27,B26)
I need to be able to enter cell b25 if b5 is less than b6. Can anyone
assist with this, please?

Advisor92.5% (cell b5)
Region89.4% (cell b6)

Below Region0.0% (cell b25)
Equal to Region1.0% (cell b26)
Above Region2.0% (cell b27)

Thank you for your help!

=if(b5gt;b6,b27,if(b5=b6,b26,b25)).
You just need to split the 'else' part of the original if formula into
another if-then-else.
--Bruce

quot;Jennifer Samuelquot; wrote:

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

=IF(B5lt;B6,B25,IF(B5gt;B6,B27,B26))

however that will return B26 if B5 and B6 are empty so you might want to use

=IF(B5=quot;quot;,quot;quot;,IF(B5lt;B6,B25,IF(B5gt;B6,B27,B26)))--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

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