Difference Ignoring Negative Numbers

psvoaofficehelp

New Member
Joined
Mar 24, 2016
Messages
2
Hello,

I am trying to find a formula that will find the difference between two columns but ignore negative numbers in any of the columns. Column A ("Gross Reserve") is a reserve for an insurance claim (the amount we expect to pay) and Column B ("Amount Paid") is the amount we have actually paid. When a claim is started, the deductible is billed, which makes Column B a negative number until we have paid more than the deductible amount. I need a formula in Column C "Reserve" that will show how much of the money we expect to spend is left after subtracting the amount we have actually paid. I want Column C to display the full amount in Column A if Column B is negative.

Ex:
Column A | Column B | Column C
$50,000 | $10,000 | $40,000
$30,000 | ($2,500) | $30,000

Is there a formula that can do this?

P.S. Thank you so much in advance to anyone who can help this Excel novice.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
Hello & Welcome to the Board,

It seems like this should do it...

C1 copied down >> =IF(B2<0,A2,A2-B2)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,892
Messages
5,598,693
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top