Calculating one of two colums with a 3rd, for result?

C

Chimbo

Joined
Feb 3, 2012
Messages
1
Reaction score
0
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
 
Back
Top