ExcelGeneral"},"subject":"Re: Need Help with Nesting multiple If and statements","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:2229148"},"parent":{"__ref":"ForumTopicMessage:message:2228958"},"body":"I've never seen such a Formula ...
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... AhjanayDixonActually you do not needAND()function here. =IF(E3:E34="CONCRETE","MA...
of the type of results over the IF () function of the largest nesting (7 layer ) when, IF () function on the powerless. oapdf.com 一般情况,在EXCEL表格中大家会采用IF()函数来设计公式进行转换,这样所设计的公式会变得很复杂, 如果进行转换的成绩等级类型超过IF()函数的 最大 嵌 套( 7层 )...
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting...
I have two tabs in the same Excel spreadsheet. The first tab is a page that will be completed by the end user, who will answer questions by...
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......