Forum Discussion
brian a kennett
Feb 24, 2018Copper Contributor
Trying to write a formula
I have a spreadsheet where column A might have a Y or Not.
In column B there is a number.
I would like my formula to say if there is a Y in column A to double the number in column B.
Detlef_Lewin
Feb 25, 2018Silver Contributor
Brian,
=IF(A1="Y",2,1)*B1