SOLVED

formula to show if amounts in 3 cells are equal to each other

%3CLINGO-SUB%20id%3D%22lingo-sub-1887287%22%20slang%3D%22en-US%22%3Eformula%20to%20show%20if%20amounts%20in%203%20cells%20are%20equal%20to%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887287%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20make%20it%20obvious%20when%20a%20user%20filling%20a%20form%20has%20made%20an%20error%2C%20by%20returning%20a%20message%20in%20cell%20A5%20if%20the%20amounts%20in%20cells%20A1%2C%20B1%20and%20C1%20are%20not%20all%20equal%20to%20each%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3Dif(A1%3DB1%3DC1%2C%22n%2Fa%22%2C%22required%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3Dif((A1%2BB1%2BC1)%2F3%3DA1%2C%22n%2Fa%22%2C%22required%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eneither%20of%20which%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20like%20this%20should%20be%20simple%2C%20but%20I%20can't%20get%20my%20Saturday%20brain%20around%20it.%20Any%20suggestions%3F%3C%2FP%3E%3CP%3EP.S.%20Is%20there%20a%20%22not%20equal%20to%22%20symbol%20available%20in%20excel%20formulas%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1887287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887323%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20to%20show%20if%20amounts%20in%203%20cells%20are%20equal%20to%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887323%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869041%22%20target%3D%22_blank%22%3E%40KBoccongelle%3C%2FA%3Eshould%20be%20something%20more%20like%20%3Dif(a1%3Db1%2Cif(b1%3Dc1%2C%22n%2Fa%22%2C%22required%22)%2C%22required%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887322%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20to%20show%20if%20amounts%20in%203%20cells%20are%20equal%20to%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887322%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869041%22%20target%3D%22_blank%22%3E%40KBoccongelle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20need%20to%20apply%20an%20AND%20or%20OR%20function%20after%20the%20IF.%3C%2FP%3E%3CP%3Eie.)%20%3DIF(AND(A2%3DB2%2CB2%3DC2)%2CTRUE%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm trying to make it obvious when a user filling a form has made an error, by returning a message in cell A5 if the amounts in cells A1, B1 and C1 are not all equal to each other.

 

I've tried:

=if(A1=B1=C1,"n/a","required")

=if((A1+B1+C1)/3=A1,"n/a","required")

neither of which worked.

 

I feel like this should be simple, but I can't get my Saturday brain around it. Any suggestions?

P.S. Is there a "not equal to" symbol available in excel formulas? 

Thanks in advance!

2 Replies
Highlighted

@KBoccongelle 

You will need to apply an AND or OR function after the IF.

ie.) =IF(AND(A2=B2,B2=C2),TRUE,FALSE)

Highlighted
Best Response confirmed by KBoccongelle (Occasional Visitor)
Solution

@KBoccongelleshould be something more like =if(a1=b1,if(b1=c1,"n/a","required"),"required")