If Function for 4 Name

[Jhon Mustofa]

hi all..

how to make if formula with 4 choice or condition
like this my attachment file.

i have 4 name criteria general, specialist, expert,poor man with 4 diferent discount.

any hep, thank id advance..

john m

[Bo_Ry]

H3

=IF(G3=E$8,F$8,IF(G3=E$9,F$9,IF(G3=E$10,F$10,IF(G3=E$11,F$11,""))))

Or
=VLOOKUP(G3,$E$8:$F$11,2,)

[biex]

Extension on Bo_Ry second formula

At cell H3

Please Login or Register  to view this content.