Fahsid1230
Active Member
- Joined
- Dec 26, 2006
- Messages
- 282
Folks, Good Morning
Need your help
here is the logic:
<3 years =176
3 - 5 yeras = 192
5 - 7 years = 208
7 -10 years = 224
>10 years = 240
This is all comparing to colum which has 1 -10 (in years).
So folks, If I need to try the first logic (<3 years =176) I can write a statemen like this =if(E2<3, 176) but I dont know how to use the IF & Then statement for 3 - 5 years for a cap for 192 and so forth. Remember E is the colum to which we are comparing with.
Any help?
thx
Need your help
here is the logic:
<3 years =176
3 - 5 yeras = 192
5 - 7 years = 208
7 -10 years = 224
>10 years = 240
This is all comparing to colum which has 1 -10 (in years).
So folks, If I need to try the first logic (<3 years =176) I can write a statemen like this =if(E2<3, 176) but I dont know how to use the IF & Then statement for 3 - 5 years for a cap for 192 and so forth. Remember E is the colum to which we are comparing with.
Any help?
thx