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

 

[philwojo]

Try this:

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

 

[Joe4]

You are a bit confused in your use of double-quotes. You put them around literal text values only, not range references.
So try:

[COLOR=#333333]=IF(A1="S",B1*C1,0)[/COLOR]

 

[dougkpga]

You are right about my confusion with the double quotes. Thanks to both of you for the quick replies. Thanks given under posts.

 

[dougkpga]

I have been asked if I could modify the spreadsheet a little bit.


So now I have 3 conditions that either return a projected profit or does not return a profit.

So if there is a sale, column A = S
If there is a conditional promise to order A = C (conditional)
If there is no sale, column A = NS

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


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

My attempt was ....

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

but it didn't work.



Once again thanks in advance for any help

Doug

 

[philwojo]

Try this:

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

 

[Joe4]

Hmmm....

This wouldn't be homework, would it?

 

[dougkpga]

Thank you again Phil.

 

[dougkpga]

No sir. At age 61 I am done with homework.

 

[Joe4]

No sir. At age 61 I am done with homework.

OK. Just checking. You are never too old to learn, though!

You would be surprised how often people expect us to do their homework for them!