Excel If/and
 

In the formula, =IF(AND(M3/301, 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

Excel If/and
 

Eddy,

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

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

HTH,
Bernie
MS Excel MVP


"EDDY GOULD" wrote in message
...

In the formula, =IF(AND(M3/301, 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

Excel If/and
 

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.