| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statement
I'm trying to use "IF" to do a calculation. What I need to do is run one of
two calculations based on the contents of a cell. Example: If A1="Salary" Sum(B1*12). If A1="Hourly" Sum(B1*2080). A1 is always going to be either Salary or Hourly and B1 is the rate of Pay. This is to calculate an annual salary. Please help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If statement
=IF(A1="Hourly",B1*12,B1*2080)
Or, slightly shorter =B1*IF(IfA1="Hourly",12,2080) Note that you don't need SUM -- Kind regards, Niek Otten Microsoft MVP - Excel "robertm600635" wrote in message ... | I'm trying to use "IF" to do a calculation. What I need to do is run one of | two calculations based on the contents of a cell. Example: If A1="Salary" | Sum(B1*12). If A1="Hourly" Sum(B1*2080). A1 is always going to be either | Salary or Hourly and B1 is the rate of Pay. This is to calculate an annual | salary. Please help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If statement
No IFs are needed:
=((A1="Hourly")*2080+(A1="Salary")*12)*B1 -- Gary''s Student - gsnu200722 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If Then Statement Help | Excel Discussion (Misc queries) | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
