Forum Discussion
Nesting IF statements with IF/AND statements
Hi, I need help making sure this conditional statement is correct, I keep getting an error. I am trying to say if E3:E34 equals CONCRETE, then put MANHOLE REHABILITATION, and if D3:D34 is less t...
AhjanayDixon Actually you do not need AND() function here.
=IF(E3:E34="CONCRETE","MANHOLE REHABILITATION",IF(D3:D34<12,5,6))See the attached file.
It worked!! Thank you so much Harun24HR