G
Guest
Guest
I tried the following IF function:
=IF(a1=Y, b1*1.03, b1*1.25) and it did not
work.
If there is a Y in Column A I want to output Column B multiplied by 1.03 otherwise I want it to output Column B muliplied by 1.25.
Any suggestions?
=IF(a1=Y, b1*1.03, b1*1.25) and it did not
work.
If there is a Y in Column A I want to output Column B multiplied by 1.03 otherwise I want it to output Column B muliplied by 1.25.
Any suggestions?