I have in row B2 and B3 a static number in them ie 5000, in C2 and C3 a
entered number, and in D2 and D3 it is the difference between these.
In E5 this is the total amount required to balance B@ and B3, I can work
this out but what I require in E5 is a 0 if cells C2 and C3 are empty. E5
product is linked into another sheet.
ie
Actual Count Required to balance
B2 5000 C2 3000 D2 2000
B3 5000 C3 4000 D3 1000

E5 3000

if you want it to be 0 if either c2 or c3 are empty
if(or(c2="",c3=""),0,d2+d3)
if you want it to be 0 only if both are empty
=if(and(c2="",c3=""),0,d2+d3)
--
paul

remove nospam for email addy!



"bbc1" wrote:

I have in row B2 and B3 a static number in them ie 5000, in C2 and C3 a
entered number, and in D2 and D3 it is the difference between these.
In E5 this is the total amount required to balance B@ and B3, I can work
this out but what I require in E5 is a 0 if cells C2 and C3 are empty. E5
product is linked into another sheet.
ie
Actual Count Required to balance
B2 5000 C2 3000 D2 2000
B3 5000 C3 4000 D3 1000

E5 3000

Thanks that works great but the boss now wants if one cell is empty and the
other has a value in it to give a result..

"paul" wrote:

if you want it to be 0 if either c2 or c3 are empty
if(or(c2="",c3=""),0,d2+d3)
if you want it to be 0 only if both are empty
=if(and(c2="",c3=""),0,d2+d3)
--
paul

remove nospam for email addy!



"bbc1" wrote:

I have in row B2 and B3 a static number in them ie 5000, in C2 and C3 a
entered number, and in D2 and D3 it is the difference between these.
In E5 this is the total amount required to balance B@ and B3, I can work
this out but what I require in E5 is a 0 if cells C2 and C3 are empty. E5
product is linked into another sheet.
ie
Actual Count Required to balance
B2 5000 C2 3000 D2 2000
B3 5000 C3 4000 D3 1000

E5 3000