Excell Calculations

[Muddled]

I need to calculate as follows. In cell D12 I Have an item for $35.00. In D13
an option for $3.00. In D14 the sum of these two. I only want the sum to show
up when there is a value other than 0 in the option cell (D13). Is this
possible?

 

[Gord Dibben]

In D14.................

=IF(D13=0,"",D12+D13)


Gord Dibben MS Excel MVP

 

[Muddled]

Thank you. That did the trick.
--
Ralphy

In D14.................

=IF(D13=0,"",D12+D13)


Gord Dibben MS Excel MVP