I am trying to build a formula that can test a greater than, less than criteria and return and number.
example 20<a1<30. I can get a result with using either less than or greater than, but get a 0 when i use both. how do i get around this.
I am trying to build a formula that can test a greater than, less than criteria and return and number.
example 20<a1<30. I can get a result with using either less than or greater than, but get a 0 when i use both. how do i get around this.
=if(and(a1>20,a1<30),"your desired result","other text")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
thanks, oeldere. I will give it a try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks