Multiple IF functions

[Harry S]

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

 

[Bob Phillips]

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

 

[Pete_UK]

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

 

[Coreen M. Harris, New Zealand]

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]

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