Hi,

=IF($A1388="z","",IF(AW1388="","N/A",IF(COUNTIF(Sheet1!AI$4:AI$2000,AW1388)=1,"","CH G")))

Deciphering the formula is a logical process and I've corrected this one for
the REF# error which is caused by an invalid worksheet reference. I can't
know the name of that sheet so i've used Sheet1.


Break the formula in pieces and evaluation starts form the left and stops as
soon as a condition evaluates as TRUE

IF($A1388="z","",
If A1388 of the current sheet contains a z then the formula stops with "" or
a null string in the cell. Try it and put a z in that cell

IF(AW1388="","N/A"
If there is no z then evaluation continues and looks for a blank cell (null
string) in AW1388. If that's true evaluation stops with N/A in the cell.

IF(COUNTIF(Sheet1!AI$4:AI$2000,AW1388)=1
If that evaluates as false evaluation continues with a countif on sheet1 (or
whatever sheet that was). It counts the instances of the contents of AW1388
in the range AI4 AI2000 and ensures it only appears once and if it does then
the cell is populated with a null string ""


,"CHG")))
The last argument populates the cell with CHG if all the above evaluate as
false.

Mike


"Kell2604" wrote:

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