If values in 2 cells matches criteria, add text to a third cell

Originally Posted by prizm

Try this
= IF(AND(A1="photo",A2>=20),"XL","")

Maybe in the lines of the formula above, if you need to apply it in code you can use the IF loop -

if range("A1").value = "Photo" and range("A2").value >=20 then
      range("A3").value="XL"
else
      range("A3").value=""
end if

Just change the cell references where required.