Formula Problem

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?

Very many thanks

david
 
J

JE McGimpsey

If I understand you correctly, this should work:

=IF(ISBLANK(H55),H54+H56,IF(H55<>"",H55+H56,""))
 
R

RagDyer

If H55 contains a zero, then it's still added to H56.

=(H55<>"")*(H55+H56)+(H55="")*(H54+H56)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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?

Very many thanks

david
 
D

David M

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
 
C

Cutter

Try substituting

=if(h55<>"",h55+h56,if(h55="",h54+h56,""))

with

=if(h55<>"",h55+h56,if(LEN(H55)=0,h54+h56,""))

or simpler version

=if(len(h55)=0,h54+h56,h55+h56
 
R

RagDyeR

In that case, just change the null to zero, and try this:

=(H55<>0)*(H55+H56)+(H55=0)*(H54+H56)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




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
 
D

DavidM

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
 
R

Ragdyer

Thanks for the feed-back ... BUT ... you did waste the time of a number of
people by creating a new post for this same question.

You see how they duplicated the suggestions that you received here, which
didn't solve your problem because *you DIDN'T* state your problem correctly,
in the first place.
 
Top