Formula Error

  • Thread starter Thread starter PR
  • Start date Start date
P

PR

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
 
What error? Do you mean FALSE? You have not given your first IF() a return
if the result of K1>=2, is FALSE

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Is this what you want

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


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Paul,

I'm not sure if I understand your problem but if you are comparing
individual values in column K to those in column Q then your function would
read =IF(K1=Q1,"Agree","Does not agree")
 
Thanks too all who have tried to answer my qestion... Bob forumla works...

many thanks

Paul
 
Your formula "fail". It returns "agree" when either K1 or/and Q1 are text

Here is the correction:
=IF(AND(COUNT(K1,Q1)=2,K1>=2,Q1>=2),"agree","not")
 
Your formula "fail". It returns "agree" when either K1 or/and Q1 are text

Here is the correction:
=IF(AND(COUNT(K1,Q1)=2,K1>=2,Q1>=2),"agree","not")
 
If K1=2 and Q1=3 your results "Does not gree".Fail. OP wants if K1>=2 and
Q1>=2 and return "agree"

If K1=apple, Q1=apple your results "agree". FAIL
 
I am confused! Is it that PR wants to return the value "Agree" if both K1 and
Q1 are greater than or equal to 2. So if K1 was 5 and Q1 was 8 the function
would return the value "Agree"?

PC
 
Back
Top