Hi - apologies, as I'm sure this thread has been rehashed hundreds of times, but I searched through a few of them and none quite solved my problem as it currently is (most are attempting to solve the reverse...)
Essentially, I want to tell the spreadsheet that if any cell in Column B is filled (eg. B2) then the corresponding cell in Column C (C2) should automatically fill with "n/a" or "not needed" (in my actual spreadsheet, it would need to say "Probable Date Not Required".
There is a slight complication - the only time I do not want Column C to fill automatically is if Cell B2 says "No Certain Date". So I think I'm looking for a formula that reads roughly (this is a crude example) =(NOT(IFBLANK)="Probable Date Not Required" UNLESS B="No Certain Date")
Obviously the above is not correct, but hopefully it will make it clearer to someone what I'm after! Thanks for any help that you guys and girls can offer.
Essentially, I want to tell the spreadsheet that if any cell in Column B is filled (eg. B2) then the corresponding cell in Column C (C2) should automatically fill with "n/a" or "not needed" (in my actual spreadsheet, it would need to say "Probable Date Not Required".
There is a slight complication - the only time I do not want Column C to fill automatically is if Cell B2 says "No Certain Date". So I think I'm looking for a formula that reads roughly (this is a crude example) =(NOT(IFBLANK)="Probable Date Not Required" UNLESS B="No Certain Date")
Obviously the above is not correct, but hopefully it will make it clearer to someone what I'm after! Thanks for any help that you guys and girls can offer.
