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