Microsoft Excel Question

[Dmiles23]

I'm doing a project on Excel, and have the following question:

 

I'm using a formula, and taking numbers from other columns on the page and using them in the formula. But in these formulas, I would like the box to remain blank if the formula contains a certain number from a specific column. This is hard to explain, but say I have the following formula: =((3*N2)+(5*O2))/B2. I would like a number appear in the box if the number in the O2 column is anything other than zero; but if the O2 column has a value of zero, I would like the formula box to remain blank.

 

I remember doing this in college accounting, but can't for the life of me remember how to do this. Any help would be great. Thanks a ton!!

[valpocrewsader]

=IF(O2 = 0, "", ((3*N2)+(5*O2))/B2)

[Dmiles23]

Thanks A TON!!