ExcelBanter - conditional statement =IF(A1<B1,"<",IF(A1=B1,"=","")) <--- don't

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

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

- - conditional statement =IF(A1<B1,"<",IF(A1=B1,"=","")) <--- don't (https://www.excelbanter.com/excel-worksheet-functions/235972-conditional-statement-%3Dif-a1-b1-if-a1%3Db1-%3D-dont.html)

out0015

conditional statement =IF(A1<B1,"<",IF(A1=B1,"=","")) <--- don't

A B C D
E F

3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60

Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 2221. 6781 in column D is less than 6781
in column A 49+6= 5550.

out0015

conditional statement =IF(A1<B1,"<",IF(A1=B1,"=","")) <--- don't

"out0015" wrote:

A B C D E F

3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60

Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 2221. 6781 in column D is less than 6781
in column A 49+6= 5550.

All times are GMT +1. The time now is 05:40 AM.