Forum Discussion
Multiple Arguments
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
4 Replies
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.
- Hi Hans Vogelaar,
Thank you for your response. I have entered your formula but it doesn't seem to be working. 'Scaffold Required' columns that contain N/A are not coming across as N/A in column 'Scaffold Complete'.
Any suggestions?
ElliotIt appears to work for me...
Could you attach a sample workbook without sensitive information that demonstrates the problem?
