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)

--


Gary


"FIRSTROUNDKO via OfficeKB.com" <u15639@uwe wrote in message
news:5da5050029689@uwe...
HI,

can somebody please expalin in plain english what this lines of codes do

Worksheets(SheetNotification).Range("m" & 19).Value = "=IF(RC[-4]<0,RC[-11],
R6C3)"

Worksheets(SheetNotification).Range("j" & 19).Value = "=RC[1]/RC[-1]"

Thanks in Advance

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1