Multiple Arguments

Copper Contributor

Hi All,

 

I have the following data set;

 

Scaffold RequiredScaffold Return Date?Scaffold Complete
Yes01/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

@Serdet 

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?

Elliot

@Serdet 

It appears to work for me...

 

S0350.png

 

Could you attach a sample workbook without sensitive information that demonstrates the problem?

Hi Hans Vogelaar,

It appears there was a problem on my end but it all seems to be working now.

Thank you very much for your help.

Have a good day!
Elliot