Solved

MS Excel Formula Result not displayed

Posted on 2014-07-29
7
110 Views
Last Modified: 2014-07-30
Hello,
This is so strange and I can't see what the problem is.  I am sure it has a very simple solution.
And the cell format is the same.Column not True or FalseColumn J does not want to show the TRUE or FALSE, as does I;
0
Comment
Question by:chima
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 8

Assisted Solution

by:itjockey
itjockey earned 100 total points
ID: 40227874
One shortcut solution - Delete column J - Add new column. So if any formatting issue.Then it will be resolved .

Thanks
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40227948
Column J is probably formatted as Text; change the cell(s) or entire column to "General" then press [F2] and [Enter] on that first cell in J1.

-Glenn
0
 
LVL 13

Assisted Solution

by:duncanb7
duncanb7 earned 200 total points
ID: 40228435
probably is issue at  A1 and k1 that let comparsion  result will return to Null
You can try =ISERROR(IF(A1=K1,TRUE,FALSE)), it will prove it if return to True from iserror()

A1 may have  this  #value or K1 may have this #DIV something like that

Duncan
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 27

Accepted Solution

by:
Glenn Ray earned 200 total points
ID: 40228521
@Duncan,
If there was an error in either A1 or K1, that error would display in J1 (where this formula is).

It HAS to be that the cell is formatted as Text OR "Show Formulas" is turned on (not likely).
0
 

Author Comment

by:chima
ID: 40229296
Hello everyone, while duncanb7's solution worked in one column, for whatever the reason does not work on other columns.  I have looked at all of the cell's formatting and this does not solve the problem totally.
To add more clarification to the origin of this problem; the content of this Excel file comes from the conversion of a pdf to txt, then opened with Excel to form the xlsx file.  I suspect that through all of the conversions the content got corrupt.
This issue is not all that important for me solve at this time, so I am tabling the problem, but issuing the points shortly.
Thank you all for the help.
0
 

Author Closing Comment

by:chima
ID: 40229595
Thanks
0
 
LVL 13

Expert Comment

by:duncanb7
ID: 40229597
Thx for your ot

Have a nice day

Duncan
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now