Forum Discussion
AhjanayDixon
Sep 19, 2024Copper Contributor
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 than 12, then input value 5. If it is more than 12 then input value 6.
2 Replies
- Harun24HRBronze Contributor
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.
- AhjanayDixonCopper ContributorIt worked!! Thank you so much Harun24HR