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 c...
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?
- 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
