| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Hi
something along the lines of =IF(AND(A1=1,A1<=10),"yes","no") Cheers JulieD "laurieevan" wrote in message ... Want to return a value based on a whether a number is within a range of numbers using the IF function. Can someone please give me the correct syntax. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to return "0" based on another cell | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Subtracting based on number of miles | Excel Discussion (Misc queries) | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
