Forum Discussion
Solved
#N/A Error
This formula is trying to check if the contents of a cell C37 is either 0% in which case nothing happens or if it does not equal 100% text is entered into cell D37. Cell D37 holds the formula. Th...
=IFS(C37=0%," ", C37<>100%," Shareholder values do not equal 100%. Please review and correct.", C37=100%," Shareholder values equal 100%.")You can add a condition if C37 equals 100% and a corresponding result. With this the formula doesn't return N/A in my sheet.
=IFS(C37=0%," ",
C37<>100%," Shareholder values do not equal 100%. Please review and correct.",
C37=100%," Shareholder values equal 100%.")You can add a condition if C37 equals 100% and a corresponding result. With this the formula doesn't return N/A in my sheet.
Great, thank you.
Still struggling to see what I was doing. But all ok now.
Still struggling to see what I was doing. But all ok now.