G Guest Apr 9, 2005 #1 Everytime i type that condition into an if statement it doesnt calculate the number correctly... what am i doing wrong?
Everytime i type that condition into an if statement it doesnt calculate the number correctly... what am i doing wrong?
N Niek Otten Apr 9, 2005 #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
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
G Guest Apr 11, 2005 #4 You can also use boolean conditions like: =(A1>1) * 1 -> checks one condition =(A1>2) * (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 here: http://www.pdbook.com/index.php/excel/binary_switch_formulas/
You can also use boolean conditions like: =(A1>1) * 1 -> checks one condition =(A1>2) * (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 here: http://www.pdbook.com/index.php/excel/binary_switch_formulas/
