Logical Functions

  • Thread starter Thread starter FRN
  • Start date Start date
F

FRN

I am working on a spreadsheet for compensation
and I need help with the Add’t mths columns.
The spreadsheet should take Years of service
in column B and calculate additional months
(0,1 or 2 months) of severance base on years
of service. Below is an example of the
spreadsheet an as I said column E is what I
need help on to write a formula.

A B C D E
1 Annual RT Years of Service Mnths Of Severance Severance $ Add't mths

2 35700 21 12.5 $37,187.50 2
3 43500 10 6 $21,750.00 1
4 24800 6 3.02 $6,241.33 0

Column E add’t mths is where I need help.
I need that column to reflect the following:

IF B2 > or = to 20 should show 2
IF B2 > or = to 10 should show 1
IF B2 < 10 should show 0

I need all these options in one formula in cells
E2, E3, E4 and so on. Can you Help me?
FRN
 
You need to do this as a nested if statment. Tyr this:

=if(b2>=20,2,if(b2>=10,1,0))
-----Original Message-----

I am working on a spreadsheet for compensation
and I need help with the Add't mths columns.
The spreadsheet should take Years of service
in column B and calculate additional months
(0,1 or 2 months) of severance base on years
of service. Below is an example of the
spreadsheet an as I said column E is what I
need help on to write a formula.

A B C D E
1 Annual RT Years of Service Mnths Of
Click to expand...
Severance Severance $ Add't mths
 
Back
Top