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
>