Thread: Excel If/and
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick
 
Posts: n/a
Default 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