Formula Problem2

D

DavidM

I am trying to raise a formula that gives me a sum of two
cells when there is a positive value present and the
following appears to satisfy this.
=IF(H55<>"",H55+H56,"")

The problem is that if the cell H55 is actually empty, I
want to sum two different cells in this case H54+H56.

Is there any way of achieving this with the OR or some
other function?

I received some very helpful replies to this enquiry 30th
June 2004 but..............
I am getting there :)
Every one of the suggestions worked but only when I
deleted the content of cell H55. Cell H55 actually holds a
formula for giving me the percentage (discount) from cell
H54 ie. =H54*(1-$B$60%) where my variable discount
figure is in B60
Unfortunately with the formula present in H55 none of the
suggestions work.

Can this be overcome?

TIA

david
 
A

Arvi Laanemets

=(H55="")*SUM(H54)+SUM(H55:H56)

SUM function is used for case there are formulas in H54:H56, not actual
values.
 
D

David M

Many thanks to everyone - Rag Dyer actually came up with
the answer:
=(H55<>0)*(H55+H56)+(H55=0)*(H54+H56)

Once again thanks to all

david
 
Top