Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) |