Quick formula

[Guest]

I think I'm confusing "if" with "or"...please help. I want cell A to use the
value in cell B if there is one, otherwise I want cell A to use the value in
cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to
work.

 

[Guest]

try this
=IF(B1>0,B1,C1*2.25)

 

[Roger Govier]

Hi

=IF(B1,B1,C1)*2.25

 

[Guest]

IF(B1=0,C1*2.25,B1)

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Great...thank you very much.

try this
=IF(B1>0,B1,C1*2.25)