| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reading a formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not reading imported data | Excel Worksheet Functions | |||
| date reading formula question | Excel Worksheet Functions | |||
| Formula for Reading A Non-Existent Reference | Excel Worksheet Functions | |||
| Formula reading formula instead of cell content | Excel Worksheet Functions | |||
| IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions | |||
Threaded Mode
