Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Excel Formula Result not displayed

Posted on 2014-07-29
7
Medium Priority
?
116 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:Naresh Patel
Naresh Patel earned 400 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 800 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 27

Accepted Solution

by:
Glenn Ray earned 800 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 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