Excel - Refer to Column on current row

[RHelman]

Hi,
if i write a formula such as:

=IF($C:C=3,IF($J:J="N/A"," ",(IF($J:J=""," ",(IF(MONTH($J:J)=12,$L:L," "))))),"")

will it treat $C:C and $J:J as referring to the value in column C of the row the formula appears in?

Thank you.

 

[SkipVought]

hi,

If your formula is in row 2...
[tt]
=IF($C2=3,IF($J2="N/A"," ",(IF($J2=""," ",(IF(MONTH($J2)=12,$L2," "))))),"")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}