Excell Calculations
 

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?
--
Ralphy

Excell Calculations
 

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

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


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 16:44:01 -0700, Muddled
wrote:

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?

Excell Calculations
 

Thank you. That did the trick.
--
Ralphy


"Gord Dibben" wrote:

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

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


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 16:44:01 -0700, Muddled
wrote:

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?