I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S

=IF(A10<5,x1+1,IF(AND(A105,A10<10),X1+2,IF(AND(A1 010,A10<20),X1+3)))


--
__________________________________
HTH

Bob

"Harry S" wrote in message
...
I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S

Do it like this:

=if(a10<5,x1+1,if(a10<10,x1+2,if(a10<20,x1+3,"out of range")))

You have already tested for A10 being less than 5 when you get to the
second IF, so you don't need to test it for that condition again.
Similarly for when you get to the third IF.

Hope this helps.

Pete

On Sep 24, 3:39*pm, Harry S wrote:
I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S

Good morning Pete_UK
I, Coreen, am needing your help. Similar to the previous you helped with,
thus how would you write a COUNTIF function from one worksheet into another
worksheet of the same workbook?
Thank you for your time and kindness,
Coreen_NZ

"Pete_UK" wrote:

Do it like this:

=if(a10<5,x1+1,if(a10<10,x1+2,if(a10<20,x1+3,"out of range")))

You have already tested for A10 being less than 5 when you get to the
second IF, so you don't need to test it for that condition again.
Similarly for when you get to the third IF.

Hope this helps.

Pete

On Sep 24, 3:39 pm, Harry S wrote:
I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S

Well, suppose you wanted a count in Sheet2 of the numbers in column A
of Sheet1 which are greater than 5 - you could do that like this:

=COUNTIF(Sheet1!A:A,"5")

This is just an example - if you want a more specific answer then you
will need to supply some more details of what it is that you want to
do.

Hope this helps.

Pete

On Sep 24, 7:58*pm, Coreen M. Harris, New Zealand <Coreen M. Harris,
New wrote:
Good morning Pete_UK
I, Coreen, am needing your help. Similar to the previous you helped with,
thus how would you write a COUNTIF function from one worksheet into another
worksheet of the same workbook?
Thank you for your time and kindness,
Coreen_NZ



"Pete_UK" wrote:
Do it like this:

=if(a10<5,x1+1,if(a10<10,x1+2,if(a10<20,x1+3,"out of range")))

You have already tested for A10 being less than 5 when you get to the
second IF, so you don't need to test it for that condition again.
Similarly for when you get to the third IF.

Hope this helps.

Pete

On Sep 24, 3:39 pm, Harry S wrote:
I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S- Hide quoted text -

- Show quoted text -