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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the value of a percentage 2
Combine Two Colums 3
Comparing two columns and returning value from another column 1
Adding a column of numbers, with a condition 3
Having a problem with calculating medians in access 1
Formula required for matching cells 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula to return desired Result 4

Top