Can Formula be the result of the =IF function

Feb 19th, 2002, 01:51 PM

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?

NateO · Feb 19th, 2002, 01:55 PM

Try this:

=IF(a1="Y", b1*1.03, b1*1.25)

Cheers,

Nate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 01:51 PM	#1
Guest Posts: n/a	I tried the following IF function: =IF(a1=Y, b11.03, b11.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?

Feb 19th, 2002, 01:55 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Try this: =IF(a1="Y", b11.03, b11.25) Cheers, Nate