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.
The cell it is checking is set as a % and the cell doing the checking is General.
It keeps giving me a #N/A error.
=IFS(C37=0%," ",C37<>100%," Shareholder values do not equal 100%. Please review and correct.")
Any help please?
=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.
2 Replies
=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.
