ExcelBanter - Positive Results

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Positive Results (https://www.excelbanter.com/excel-worksheet-functions/41336-positive-results.html)

lmthomas

Positive Results

How can I use a formula to subtract a number in one cell from a number in
another cell then display the result only if it is positive or greater than 0?

[email protected]

It would look something like this:

=IF(a1-a2=0,a1-a2,"")

Duke Carey

=if(a1=b1,a1-b1,"")

"lmthomas" wrote:

How can I use a formula to subtract a number in one cell from a number in
another cell then display the result only if it is positive or greater than 0?

lmthomas

That did it! Thank you for your help.

" wrote:

It would look something like this:

=IF(a1-a2=0,a1-a2,"")

All times are GMT +1. The time now is 01:36 AM.