'if or' formual help please!

[Stephen.Nichols]

Hi

Trying to create the following in D1;

If A1 = 0, then return B1 OR if A1 = 1 then return B1 x C1

I can do the first part with =if(A1=0, B1,0) ... just need help with the second part.

Can anyone help?

 

[asking]

Try

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

Cheers

 

[villy]

You can try this simple formula:
=IF(A1=0,B1,IF(A1=1,B1*C1,0))

 

[Stephen.Nichols]

Great, Thank you!

 

[villy]

Welcome...