excel formula formatting questoin-settlement check data
I want to show the change in XYZ from visit to the next. There are slight differences in the data from one visit to the next. i have a formatting problem in that I would like the cell to return NO CHANGE with they differences in the values is 0.00 . For some reason, some other value is always returned ,i.e. North , South, East,West , Up, Down. Any suggestion on how to fix this?nAny suggestions on conditional formmating? A sample formula is below
=IF(‘BASIS VISIT’!B3=’VISIT 1′!B3,”NOCHANGE”,IF(‘BASIS VISIT’!B3>’VISIT 1′!B3,”SOUTH”,IF(‘BASIS VISIT’!B3<‘VISIT 1’!B3,”NORTH”)))
thanks for your help
Log in to reply.