possible to multiply IF on 1 cell ?

[bkcffee]

Hello

1st check the attachment, plz note that it has 3 sheets

wt im trying to do is a formula in "indemnity" column that link between Period Years and Remarks column with Indemnity SHEET!!

Results
if Remarks = End of Service, then 100% no matter wt period it has
if Remarks = Special Case Termination , then Zero no matter wt period it has
now the trick
if Remarks = Resign, Absent From Duty, Run Away,
Indemnity should be
100% If Period >=10
75% If Period >=5 <10
50% If Period >=3 <5
Zero If Period <3

hope u got it :P

and Thanks in advance <3

[sandy666]

try

Please Login or Register  to view this content.

[JohnTopley]

Try

=IF(F3="End of Service",100%,IF(F3="Special Case Termination",0%,IF(OR(F3="Resign",F3="Absent from Duty",F3="Run Away"),VLOOKUP(E3,$N$2:$O$5,2,1))))

N2:O5 contains table below:

0 0.00%
3 50.00%
5 75.00%
10 100.00%

[bebo021999]

Another one:

=IF(F3="End of Service",100%,IF(F3="Special Case Termination",0%,IF(OR(F3={"Resign","Absent from Duty","Run Away"}),LOOKUP(E3,{0,3,5,10},{0,0.5,0.75,1}))))