ExcelBanter - if formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if formula (https://www.excelbanter.com/excel-discussion-misc-queries/246087-if-formula.html)

Gerry

if formula

i have two columns with number data. i want the difference between the two
columns be in the third column if the first column is greater than the second
column and on the fourth column if the first column is lesser than the
second column

Mike H

if formula

Hi,

Assuming your number in cols A&B.

This in C1
=IF(A1B1,A1-B1,"")
This in d1
=IF(B1A1,B1-A1,"")

Drag both down.

Mike

"gerry" wrote:

i have two columns with number data. i want the difference between the two
columns be in the third column if the first column is greater than the second
column and on the fourth column if the first column is lesser than the
second column

All times are GMT +1. The time now is 05:09 PM.