ExcelBanter - Formula

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

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

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/254215-formula.html)

sjl

Formula

Hi. I have Startsheet and Jansheet, I want a formula to compare C2 in
JanSheet with C2 in Startsheet. If equal then "1" to appear in D2, if less
then "i" to appear in D2 and if greater then "h" to appear in D2. Any help
greatlt appreciated.

Thanks

David Biddulph[_2_]

Formula

=IF(C2<Startsheet!C2,"i",IF(C2=Startsheet!C2,1,"h" ))
--
David Biddulph

"SJL" wrote in message
...
Hi. I have Startsheet and Jansheet, I want a formula to compare C2 in
JanSheet with C2 in Startsheet. If equal then "1" to appear in D2, if less
then "i" to appear in D2 and if greater then "h" to appear in D2. Any help
greatlt appreciated.

Thanks

sjl

Formula

Thank you.

"David Biddulph" wrote:

=IF(C2<Startsheet!C2,"i",IF(C2=Startsheet!C2,1,"h" ))
--
David Biddulph

"SJL" wrote in message
...
Hi. I have Startsheet and Jansheet, I want a formula to compare C2 in
JanSheet with C2 in Startsheet. If equal then "1" to appear in D2, if less
then "i" to appear in D2 and if greater then "h" to appear in D2. Any help
greatlt appreciated.

Thanks

.

All times are GMT +1. The time now is 10:32 PM.