S
sandy
Using Excel 2003. I've tried, I just can't do this and need some help
please...(both table and data are representative of current spreadsheets).
Table (age col A; years of service Row 1)
A B C D E
1 30 29 28 27
2 62 100 100 100 100
3 61.5 100 100 100
4 61 100 100
5 60.5 100
Data: Col A = age; Col B = yrs/svs
A B
1 54.5 28.2
2 61.8 29.2
3 23.6 11.8
How do I ask if age is more than 61 and yrs/svs more than 29, then 100, if
not N/A? I will have to do this with several thousand rows with age range
from 21 to 75, and yrs of svs similarly spanned.
Thankyou for your help.
please...(both table and data are representative of current spreadsheets).
Table (age col A; years of service Row 1)
A B C D E
1 30 29 28 27
2 62 100 100 100 100
3 61.5 100 100 100
4 61 100 100
5 60.5 100
Data: Col A = age; Col B = yrs/svs
A B
1 54.5 28.2
2 61.8 29.2
3 23.6 11.8
How do I ask if age is more than 61 and yrs/svs more than 29, then 100, if
not N/A? I will have to do this with several thousand rows with age range
from 21 to 75, and yrs of svs similarly spanned.
Thankyou for your help.