SOLVED

#N/A Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3269115%22%20slang%3D%22en-US%22%3E%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269115%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20formula%20is%20trying%20to%20check%20if%20the%20contents%20of%20a%20cell%20C37%20is%20either%200%25%20in%20which%20case%20nothing%20happens%20or%20if%20it%20does%20not%20equal%20100%25%20text%20is%20entered%20into%20cell%20D37.%20Cell%20D37%20holds%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cell%20it%20is%20checking%20is%20set%20as%20a%20%25%20and%20the%20cell%20doing%20the%20checking%20is%20General.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20keeps%20giving%20me%20a%20%23N%2FA%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFS(C37%3D0%25%2C%22%20%22%2CC37%26lt%3B%26gt%3B100%25%2C%22%20Shareholder%20values%20do%20not%20equal%20100%25.%20Please%20review%20and%20correct.%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3269115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3269135%22%20slang%3D%22en-US%22%3ERe%3A%20%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269135%22%20slang%3D%22en-US%22%3EGreat%2C%20thank%20you.%3CBR%20%2F%3EStill%20struggling%20to%20see%20what%20I%20was%20doing.%20But%20all%20ok%20now.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3269127%22%20slang%3D%22en-US%22%3ERe%3A%20%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1345773%22%20target%3D%22_blank%22%3E%40The-WOD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFS(C37%3D0%25%2C%22%20%22%2C%0AC37%26lt%3B%26gt%3B100%25%2C%22%20Shareholder%20values%20do%20not%20equal%20100%25.%20Please%20review%20and%20correct.%22%2C%0AC37%3D100%25%2C%22%20Shareholder%20values%20equal%20100%25.%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYou%20can%20add%20a%20condition%20if%20C37%20equals%20100%25%20and%20a%20corresponding%20result.%20With%20this%20the%20formula%20doesn't%20return%20N%2FA%20in%20my%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
best response confirmed by The-WOD (New Contributor)
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.

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