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?
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
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" <[email protected]> wrote in message
news:[email protected]...
> Everytime i type that condition into an if statement it doesnt calculate
> the
> number correctly... what am i doing wrong?
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/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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks