| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i calculate a three variable if statement in excel
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(B5B6,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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel to Calculate All Combinations of a Set of Data? | Excel Worksheet Functions | |||
| How do I calculate hours in Excel | New Users to Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How can I create an IF statement in Excel that uses the word "con. | Excel Worksheet Functions | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Threaded Mode
