Nov 17 2021 10:40 AM - edited Nov 17 2021 10:41 AM
Nov 17 2021 10:51 AM
=IF(A1="$60","$500",IF(A1="$120","$1000","$0"))
Is this what you are looking for? I understand that you want to enter "$60" or "$120" in A1, not "60" or "120".
Nov 17 2021 11:01 AM
Nov 17 2021 11:13 AM
Solution=IF(A1=60,500,IF(A1=120,1000,0))
Enter above formula in B2 and it returns 500 when 60 is entered in A1 or it returns 1000 when 120 is entered in A1 (or it returns 0 if neither 60 nor 120 is in A1).
Nov 17 2021 11:13 AM
Solution=IF(A1=60,500,IF(A1=120,1000,0))
Enter above formula in B2 and it returns 500 when 60 is entered in A1 or it returns 1000 when 120 is entered in A1 (or it returns 0 if neither 60 nor 120 is in A1).