#N/A Error

[The-WOD]

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?

[#2 · Accepted solution]

@The-WOD 

=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.

[#3]

Great, thank you.
Still struggling to see what I was doing. But all ok now.