![]() |
#8
|
|||
|
|||
![]()
I have attached a rough copy of the template I currently have set up. I have removed some columns and information, so the cells in the formula are slightly different than mentioned in previous replies.
The current formula is - =IF(AND(M3="0",P3="0",S3="0",V3="0",Y3="0",AB3="0" ,AE3="0"),"FC","NC") I only need it to apply for the "Remaining" columns for the column numbers highlighted in blue (you'll see what I mean) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
![]() |
mrry475 | Excel | 1 | 09-06-2016 09:30 AM |
![]() |
cangelis | Excel | 2 | 04-08-2015 05:55 PM |
![]() |
teza2k06 | Excel | 1 | 03-11-2015 12:44 AM |
![]() |
cangelis | Excel | 4 | 01-03-2014 09:10 AM |