Hi -

I have used basic formulas in the past but have recently started a new
position in which complicated formulas are used. I was hoping for some basic
help on how to read - or decipher - this formula (and others like it).

=IF($A1388="z","",IF(AW1388="","N/A",IF(COUNTIF(#REF!AI$4:AI$2000,AW1388)=1,"","CHG" )))

or

=IF($O646=0,"NA",IF($O646="SHIPPED",IF($AA646L646 ,"LATE TO
MPS","OT"),IF($O646L646,"LATE TO MPS","OT")))

Thanks Very Much!!
Kelley