trying to make a cell either blank or zore value
 

I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is what i
have doen with the IF function. I know i am doing something wrong but can't
see where!

Any help is greatly appreciated
Thanks

trying to make a cell either blank or zore value
 

sorry the formula is below!

=IF(d6=0,"",c6=0,"",(E5-D6+C6))


"Dobbin0_4" wrote:

I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is what i
have doen with the IF function. I know i am doing something wrong but can't
see where!

Any help is greatly appreciated
Thanks

trying to make a cell either blank or zore value
 

I think you need something along the lines of:

=IF(OR(D6="",C6=""),"",E5-D6+C6)

but you will not be able to put this in cell E5.

Hope this helps.

Pete

On Sep 16, 5:25*pm, Dobbin0_4
wrote:
I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is what i
have doen with the IF function. I know i am doing something wrong but can't
see where!

Any help is greatly appreciated
Thanks

trying to make a cell either blank or zore value
 

Ok, Thanks Pete_UK

Any ideas why i can't put this in cell E5?

"Pete_UK" wrote:

I think you need something along the lines of:

=IF(OR(D6="",C6=""),"",E5-D6+C6)

but you will not be able to put this in cell E5.

Hope this helps.

Pete

On Sep 16, 5:25 pm, Dobbin0_4
wrote:
I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is what i
have doen with the IF function. I know i am doing something wrong but can't
see where!

Any help is greatly appreciated
Thanks

trying to make a cell either blank or zore value
 

Look up "circular reference" [in Excel help & in the archives of this
group.]
--
David Biddulph

"Dobbin0_4" wrote in message
...
Ok, Thanks Pete_UK

Any ideas why i can't put this in cell E5?

"Pete_UK" wrote:

I think you need something along the lines of:

=IF(OR(D6="",C6=""),"",E5-D6+C6)

but you will not be able to put this in cell E5.

Hope this helps.

Pete

On Sep 16, 5:25 pm, Dobbin0_4
wrote:
I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no
data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is
what i
have doen with the IF function. I know i am doing something wrong but
can't
see where!

Any help is greatly appreciated
Thanks