Gary,

Thanks

Darren

Gary Keramidas wrote:
it's using M19 as the reference
so RC[-4] moves 4 columns to the left, which makes it I19
the RC[-11] moves 11 columns to the left which makes it B19
the R6C3 means column 3, row 6 or C6

=IF(I19<0,B19,$C$6)

HI,

[quoted text clipped - 8 lines]

Darren

--
Message posted via http://www.officekb.com