[Chimbo]

Hello.

My column A will contain a value if I won an amount.
My column B will contain a value if I lost an amount.

I then want to subtract that value (of either col A or col B) from the C column, but of course only if the A or B column contains a value, and output the result in column D. If there's no value in column A or B, then it's to automatically check the other column.

I'd be thrilled to know how to do that.

Thanks,
Chimbo

[bookstorelee]

Chimbo,

You can try this formula in column D, =IF(A2<>"",A2-C2,IF(B2<>"",B2-C2,"")). Hope it can help you.

Lee Li Fong
http://smartusemicrosoftoffice.blogspot.com/