how to make excel not compute when there are no values to reference

[mufan]

Hello,
I would like excel to leave a blank when there are no values in the cells that the formula references. For example, I copy and paste values into column C and D of the attached sheet. The goal is for the column B to return a 0.001 when the answer is <= to zero. This formula works fine for the cells where there are values in C and D but also returns a 0.001 when there no values in column C and D. It will change from week to week which C and D columns will have values. Another issue is that the values in C and D will sometimes be 0 and 0.....so i would want to return a 0.001 in the B column when there are 0 values in C and D. thanks for the help!

[Bo_Ry]

Maybe try at B3

=IF(C3="","",IF(D3>C3,D3-C3,0.001))

[popipipo]

Please Login or Register  to view this content.

I think this formula does the job.

[mufan]

thanks guys both of these formulas work fantastic. many thanks for your help!