Use IF function for two conditions

[wuwu]

How can I use IF function for two conditions in a cell like below:

Cell A1 contains data ABC
Cell A2 contains data 500


I would like to set a IF function in cell A3 that IF A1=ABC and A2=500,
then A3 changes to "50KGS"

 

[JulieD]

Hi

in A3
=IF(AND(A1="ABC",A2=500),"50KGS","")

the AND says both conditions have to be true for true to be returned.

Cheers
JulieD

 

[Bob Phillips]

A3: =IF(AND(A1="ABC",A2=500),"50KGS","")

--

HTH

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