Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can i make this work within an IF statement: (41<=Cell<=46)
Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong? |
#2
|
|||
|
|||
One way:
=if(and(a1=41,a1<=46),"it's between","outside") velopoav wrote: Everytime i type that condition into an if statement it doesnt calculate the number correctly... what am i doing wrong? -- Dave Peterson |
#3
|
|||
|
|||
You don't tell us what formula you used.
But probably you mean something like =IF(AND(A1=41,A1<=46),"yes","no") -- Kind Regards, Niek Otten Microsoft MVP - Excel "velopoav" wrote in message ... Everytime i type that condition into an if statement it doesnt calculate the number correctly... what am i doing wrong? |
#4
|
|||
|
|||
You can also use boolean conditions like:
=(A11) * 1 - checks one condition =(A12) * (A1<8) * 1 - both conditions must be true However, this type of conditioning does not work with text. A more detailed explanation can be found he http://www.pdbook.com/index.php/exce...itch_formulas/ ---- Regards, John Mansfield http://www.pdbook.com "velopoav" wrote: Everytime i type that condition into an if statement it doesnt calculate the number correctly... what am i doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Exec work properly (error messages on start and exit) | Excel Discussion (Misc queries) | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
how to make this work if sum=5+n2 then sum becomes the value of s. | Excel Discussion (Misc queries) | |||
Array If statement doesn't work | Excel Worksheet Functions | |||
How do I make this formula work =if(a1=(b10:b20),"good","bad"). | Excel Worksheet Functions |