Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not showing results
Hi My formulas does not want to work for some reason. Please help Sonar +-------------------------------------------------------------------+ |Filename: test3.zip | |Download: http://www.excelforum.com/attachment.php?postid=3764 | +-------------------------------------------------------------------+ -- sonar ------------------------------------------------------------------------ sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424 View this thread: http://www.excelforum.com/showthread...hreadid=400595 |
#2
|
|||
|
|||
Hi, Sorry, try this one. Regards Sonar +-------------------------------------------------------------------+ |Filename: test3.zip | |Download: http://www.excelforum.com/attachment.php?postid=3766 | +-------------------------------------------------------------------+ -- sonar ------------------------------------------------------------------------ sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424 View this thread: http://www.excelforum.com/showthread...hreadid=400595 |
#3
|
|||
|
|||
That is because the codes in sheet "Mo" are numbers and the codes in sheet "SI-2" are not. You can easily check by using: IF(NumberFromSheetMo=NumberFromSheetSI-2,1,0) You will find that it returns 0. Thus they are not equal. That's why your formula returns nothing. To fix that, select the codes on sheet "SI-2" and go to: Data - Text to columns - Finish Hope it helps. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=400595 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
displaying results and not formulas | Excel Worksheet Functions | |||
Formulas with If/ and results | Excel Worksheet Functions |