Need cell to display 0 when target cell is empty

[SlipNot]

So I've created a simple excel spreadsheet that gives you the sizes of certain parts according to the overall dimensions entered into the WIDTH and HEIGHT fields. The problem I am having is when I clear the WIDTH and HEIGHT fields, I get the base formulas displayed in the right hand side and I really want 0 or nothing at all to be displayed in these fields. I've formatted the cells to display fractions which I've never done before so I'm not sure if this has anything to with it. My guess is I need some kind of if then statement but I am not sure. Can someone help me out with this? Thanks.

[Cutter]

Hello SlipNot.

Thanks for amending your thread title.

[SlipNot]

So I've created a simple excel spreadsheet that gives you the sizes of certain parts according to the overall dimensions entered into the WIDTH and HEIGHT fields. The problem I am having is when I clear the WIDTH and HEIGHT fields, I get the base formulas displayed in the right hand side and I really want 0 or nothing at all to be displayed in these fields. I've formatted the cells to display fractions which I've never done before so I'm not sure if this has anything to with it. My guess is I need some kind of if then statement but I am not sure. Can someone help me out with this? Thanks.

[Ace_XL]

Using a simple IF statement..

=IF(B3="","",Your_formula)
and
=IF(D3="","",Your_formula)

See attached updated for Group 1