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

O

out0015

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 22>21. 6781 in column D is less than 6781
in column A 49+6= 55>50.
 
O

out0015

out0015 said:
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 22>21. 6781 in column D is less than 6781
in column A 49+6= 55>50.
Click to expand...
 

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

conditionals statements 10
conditional formatting 3
Matching dates to cells 3
IF calculation of Time 2
SumIf conditional to date range 5
adding values if the same - SUMIF in range of cells? 4
Excel formula help 1
VLookup 8

Top