Forum Discussion
KBoccongelle
Nov 14, 2020Copper Contributor
formula to show if amounts in 3 cells are equal to each other
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: =...
- Nov 14, 2020
KBoccongelleshould be something more like =if(a1=b1,if(b1=c1,"n/a","required"),"required")
gotAnAccount
Nov 14, 2020Copper Contributor
KBoccongelleshould be something more like =if(a1=b1,if(b1=c1,"n/a","required"),"required")