IF Formulas!

[johnnyatbc]

An employee is eligible for retirement if he or she satisfies at least one of the following three criteria:

(i) the employee has worked here for at least 40 years
(ii)the employee is 65 or over
(iii)the employee has worked here for at least 30 years and is 60 or over

(a) Create a worksheet that allows a person to enter in his or her age and the number of years worked. A cell in the worksheet should respond either "Congratulations! You are eligible for retirement!" or "Back to work."

(b) Add a cell that will indicate how many years it will be until the employee is eligible for retirement if he or she is not now eligible. You may use extra cells in your worksheet.

HOW DO I FIND A FORMULA THAT WILL ANSWER PART B?

 

[jim may]

Here's a Start....

Excel 2010
	A	B	C	D	E	F
1			Enter:			Results (below)
2		Age:	30			Back to Work
3		No Yrs Worked	30
4
5		Years Until Retirement:
6		More Age Years
7		More Work Years
Sheet1

Cell Formulas
Range	Formula
F2	=IF(OR(C2>=65,C3>=40,AND(C2>=60,C3>=30)),"Congratulations! You are eligible for retirement!","Back to Work")