=IF(X1="A","S$500",IF(X1="B","S$1000","S$1500"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MK" wrote in message
...
Example two column X and Y
Assign A= S$500
B = S$1000
C = S$1500
If key A in column X, Y automatic display S$500
If key B in Column X, Y automatic discplay S$1000.............

Can the above be possible