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
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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.