Apr 27 2021 05:22 AM
Hi All,
I have the following data set;
Scaffold Required | Scaffold Return Date? | Scaffold Complete |
Yes | 01/01/2020 | |
Yes | ||
N/A |
I want to apply a formula to the column 'Scaffold Complete' that will automatically input the cell Yes or N/A based on the following logic;
Yes if scaffold is required and a scaffold return date has been inputted
N/A if column 'Scaffold Required' contains the word "N/A"
Any help would be much appreciated.
Many thanks,
Elliot
Apr 27 2021 05:55 AM
Let's say the data are in columns A to C, with headers in row 1.
In C2:
=IF(OR(A2="",AND(A2="Yes",B2="")),"",IF(A2="N/A","N/A","Yes"))
Fill down.
Apr 27 2021 06:48 AM
Apr 27 2021 07:04 AM
It appears to work for me...
Could you attach a sample workbook without sensitive information that demonstrates the problem?
Apr 28 2021 12:23 AM