simple formula help

C

Cheryl

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!
 
W

WKH8919

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!
Click to expand...


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

Is it work ?

Worawat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

simple sum unless blank 5
Not sure how to write the formula 10
Change formulas in a column based on a selection. 3
Need help with formula 8
Countif with a Range of criteria 8
Simplify formula 37
Need Formula to "Adjust" to New Column Assignment 3
Help getting 2 formulas into one 2

Top