simple formula help
 

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl

simple formula help
 

Try this:

=IF(COUNTA(I1:J1)=2, J1-I1, "")

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Cheryl" wrote:

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl

simple formula help
 

This should work for you:

=IF(COUNTA(I1:J1)=2, J1-I1, "")

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Cheryl" wrote:

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl

simple formula help
 

This should work for you:

=IF(COUNTA(I1:J1)=2, J1-I1, "")

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Cheryl" wrote:

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl

simple formula help
 

This should work for you:

=IF(COUNTA(I1:J1)=2, J1-I1, "")

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Cheryl" wrote:

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl

simple formula help
 

On Nov 9, 1:50*pm, Cheryl wrote:
I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl


Try this =IF(OR(I2="",J2=""),"",J2-I2)

Is it work ?

Worawat