O
out0015
For example: column g is where <, > , = should be placed.
-for the first input 59th st has 28 total, 59th st needs to look at a, b, c
which is the first one on the list then compares, 28 = 28, then it would put
= in column g.
-second one is 6th ave. which has 50. 6th ave is the 2nd and 3rd input so
49+6=55.
50 is less than 55 so i want column g to display <.
and so on.
hope this helps.
Why should I rate a post?
Expand AllCollapse All
Manage Your Profile |Contact us
© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use
|Trademarks |Privacy Statement
-for the first input 59th st has 28 total, 59th st needs to look at a, b, c
which is the first one on the list then compares, 28 = 28, then it would put
= in column g.
-second one is 6th ave. which has 50. 6th ave is the 2nd and 3rd input so
49+6=55.
50 is less than 55 so i want column g to display <.
and so on.
hope this helps.
Was this post helpful to you?Eduardo said:Hi,
I assume your information starts in cell 1 so in column E1 enter
=IF(C1=F1,"=",IF(C1>F1,">",IF(C1="","",IF(C1<F1,"<"))))
I add an option to show blank if cell C1 is blank
Why should I rate a post?
Expand AllCollapse All
Manage Your Profile |Contact us
© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use
|Trademarks |Privacy Statement