Skipping a cell and its sum if the data is negative.

[bmccarthy]

Hello, i am creating a database that includes data taking the difference from two different sheets, however if the value of the data is a negative number it is usesless to use, and can mess up our stastical analysis.
I thought a simple formula of =(if ('sheet1'!a1)-('sheet2'!A1) < 0, " ", ('sheet1'!a1)-('sheet2'!A1)/2) would work but its causing me some problems.
Anyone have any suggestions? Please get back to me. Thank you.

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.