Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is this a valid IF statement in Excel?
Hello all,
I am new to Excel programming and was wondering if this is a valid Excel IF statement for what I want to do: "=IF(AND(RC[-4]=""NJ 07733"",RC[-12]=""981621""),""HOLMDEL"",RC[-3])" If cell, 4 cells to the left of the current cell = "NJ 07733" AND cell, 12 cells to the left of current cell = "981621" Then move "HOLMDEL" to current cell Else move the contents of cell, 3 cells to the left of current cell to the current cell. Thanks for your help ahead of time, Gabe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell color for valid if statement | Excel Discussion (Misc queries) | |||
Excel - File format is not Valid | Excel Discussion (Misc queries) | |||
<xxx is not a valid add-in error in Excel 2003 SP2 | Excel Programming | |||
Excel 2007 - Reference is not valid | Excel Discussion (Misc queries) | |||
Creating a Pivot Table from a valid SQL statement without MS Query | Excel Programming |