Can I use IF function to use a formula if true and another formula if false

[dougkpga]

Hi

I have a condition that either returns a profit or does not return a profit.

So if there is a sale, column A = S.
If there is no sale, column A = NS

If there is a sale then the return (column D) is price (Column B)*quantity (number of units) (Column C)
If no sale then the return is 0 (zero)

So using IF function I tried the following -

=IF(A1=S,"B1*C1","0")

=IF(A1=S,(B1*C1),0))

=IF(A1=S,(B1*C1),"0")

None of which gave me either the return or the zero.

Can anyone help please?

Much appreciated.

Thanks in advance Doug

 

[dougkpga]

I love excel and I love the fact that you guys have this site to help out if I get stuck which does happen occasionally when I push my boundaries... Cheers Doug

 

[philwojo]

Glad to help.

 

[Joe4]

I love excel and I love the fact that you guys have this site to help out if I get stuck which does happen occasionally when I push my boundaries... Cheers Doug

Keep pushing them! There's lots of fun stuff you can do with Excel!