Excel If/and

[EDDY GOULD]

In the formula, =IF(AND(M3/30>1, M3/30<2),C3), I am trying to get the numerical value in C3 to print in the cell with the formula. But instead of printing the numerical value, it prints "false". Is there a way to make it print the numerical value?

[Bernie Deitrick]

Eddy,

It will show the numerical value if M3 is between 30 and 60:

=IF(AND(M3/30>1, M3/30<2),C3,"M3 wasn't between 30 and 60")

HTH,
Bernie
MS Excel MVP


"EDDY GOULD" <EDDY.GOULD.28d7fa_1148563201.2996@excelforum-nospam.com> wrote in message
news:EDDY.GOULD.28d7fa_1148563201.2996@excelforum-nospam.com...
>
> In the formula, =IF(AND(M3/30>1, M3/30<2),C3, I am trying to get the
> numerical value in C3 to print in the cell with the formula. But
> instead of printing the numerical value, it prints "false". Is there a
> way to make it print the numerical value?
>
>
> --
> EDDY GOULD
> ------------------------------------------------------------------------
> EDDY GOULD's Profile: http://www.excelforum.com/member.php...o&userid=34791
> View this thread: http://www.excelforum.com/showthread...hreadid=545467
>

[Dave O]

That happens when your IF function doesn't have a FALSE option to
return. In an IF, you provide a logical test, and tell Excel what to
return when that logical test is TRUE and what to return when that
logical test is FALSE. Your IF tells Excel to return the value in C3
when the logical test is TRUE but there is no instruction for FALSE, so
Excel simply returns the word FALSE.

As a fix, you need to provide Excel an instruction for what to do when
the argument is FALSE.