May 19 2021 02:29 PM
The Excel cell will have 3 possible results...... "BLUE", "RED", or if it is left Blank/empty.
When BLUE is used, multiply by 2.
When RED is used, just return 1 (i.e. no math function, just use 1).
When the cell is Blank, as in nothing is typed,...it is default clear, I want it to either remain blank, or if there needs to be a numeric value, use 0.
=IF((OR(A1="BLUE","RED")),A1*2,1)
How do I get the formula to return a Zero (0) if the cell is blank?
May 19 2021 02:34 PM
If A1 is "BLUE", A1*2 makes no sense, you cannot multiply a word with 2.
What exactly do you want to multiply?
May 19 2021 02:41 PM
May 19 2021 02:48 PM
Solution
=IF(A1="","",IF(A1="RED",1,IF(A1="BLUE",2*B1,"?")))
If you have Excel 2019 or Excel in Microsoft 365, you can also use
=IFS(A1="",""A1="RED",1,A1="BLUE",2*B1,TRUE,"?")
May 19 2021 02:58 PM
May 19 2021 02:48 PM
Solution
=IF(A1="","",IF(A1="RED",1,IF(A1="BLUE",2*B1,"?")))
If you have Excel 2019 or Excel in Microsoft 365, you can also use
=IFS(A1="",""A1="RED",1,A1="BLUE",2*B1,TRUE,"?")