Do not return a value when adjacent cell in two columns of data is empty

Hi there. I've attached an example of the problem I need to solve. I'm trying to subtract data in column A from adjacent data in column B. The problem is that where there are blank cells in column B the value returned is calculated assuming the value in column B was zero.

Thanks very much. You have no idea how dumb I am so any help is appreciated.

Rando

Originally Posted by FDibbins

Did you upload the correct file? Col A contains dates and column B contains values from 5.02 to 7.688 - and also there sare no blanks in B?

hmmm maybe you meant B and C? If so, then try this....
=IF(C2="",B2,B2-C2)

Yes sorry. I meant B and C (I forgot I had dates in column A). I tried your suggestion and got the same 'error'. When there's a blank cell in column C it's teated as a zero. What I'd like is that in the rows that contain blanks in column C not to return anything in column D.

Thanks

Thanks that worked.