"Astroboy" wrote:
.. On Cell K4:
If input is "N" then Cell O9 shows "N"
If input is "W" then Cell O9 show "L"
If input is "L" then Cell O9 show "W"

Put in the formula bar for O9:
=IF(K4="N","N",IF(K4="W","L",IF(K4="L","W","")))

I've presumed you want O9 to appear "blank" if the input in K4 is other than
what you described above.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---