![]() |
|
#1
|
||||
|
||||
![]()
No worries Alan, I've already learned so much from you I thought it time to do something back
![]()
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#2
|
|||
|
|||
![]()
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 |