Is this IF function possible

[RichZep]

I have a spreadsheet and at the bottom are three separate totals. All totals need to be the same. These are a check to ensure there are no mistakes. We all know it can be easy not to spot transposed figures. Is it possible to have a function in a separate cell that ‘looks’ at these figures and if they are all the same it will say ‘Correct’ and if they are not the same it will show ‘Error’

Thanks for your help.

[LeroyG]

@RichZep

three separate totals

=AND(A1=A2;A1=A3)
=IF(AND(A1=A2;A1=A3)=1;"Correct";"Error")

[RichZep]

Hi LeroyG, thank you. Perfect!

[karolus]

@LeroyG

=IF(AND(A1=A2;A1=A3)=1;“Correct”;“Error”)

=IF(AND(A1=A2;A1=A3)   ;"Correct";"Error")