View Single Post
  #1   Report Post  
wuwu
 
Posts: n/a
Default Use IF function for two conditions

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"
--
wuwu