Formula Error
 

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

Formula Error
 

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


Replace @mailinator.com with @tiscali.co.uk


"PR" wrote in message
...
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

Formula Error
 

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)



"PR" wrote in message
...
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

Formula Error
 

Try it like this:

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

--
Biff
Microsoft Excel MVP


"PR" wrote in message
...
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

Formula Error
 

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")


"PR" wrote:

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

Formula Error
 

Thank you to all, Bill has answer this question... again thanks

PR

"Bob Phillips" wrote:

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)



"PR" wrote in message
...
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

Formula Error
 

Thanks too all who have tried to answer my qestion... Bob forumla works...

many thanks

Paul

"Bob Phillips" wrote:

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)



"PR" wrote in message
...
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

Formula Error
 

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")


"T. Valko" wrote:

Try it like this:

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

--
Biff
Microsoft Excel MVP


"PR" wrote in message
...
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

Formula Error
 

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")



"Bob Phillips" wrote:

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)



"PR" wrote in message
...
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

Formula Error
 

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


"BioPythonPete" wrote:

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")


"PR" wrote:

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

Formula Error
 

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

"Teethless mama" wrote:

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


"BioPythonPete" wrote:

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")


"PR" wrote:

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