I have a spreadsheet with two columns that I want to check the values in both
to see if totals agree.. I have place this in as a forumla but comes back
with an error.

the two columns are K and Q

=IF(K1=2,IF(Q1=2,"agree","Not"))

can anyone advise me what is wrong...

Regards - Paul