View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Muddled Muddled is offline
external usenet poster
 
Posts: 21
Default 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?