Excel If/and

  • Thread starter Thread starter EDDY GOULD
  • Start date Start date
E

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?
 
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
 
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.
 
Back
Top