| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
