#1
|
|||
|
|||
Using IF Statements and Formatting Issues
At work I use a network, Windows 7 and Excel 2003.
Have set up a spreadsheet using IF statements. I exceeded 7 statements and have extended the equation using &. I tried to amend an equation in a cell by clicking in the the formula bar and adding in another step. The change was accepted but the cell doesnt show the answer. It does show the formula. I checked the format of the cell and it had changed from General to Text. I changed the format back to General but still only see the formula and not the answer. The sheet is set to show product of formula and not Show Formula. I also use COUNTA in the spreadsheet and amending a formula eg the range, results in the same problem. What am I doing wrong and how can I fix it? Grateful for any assistance. |
#2
|
||||
|
||||
Have you tried editing the cell then hitting F2 ?
Eventually post your sheet or a mock up
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
I will give it a go when back at work and if necessary post a section of the spreadsheet. Thanks for your guidance. |
#4
|
|||
|
|||
I tried the suggestion without success.
I have attached a section of the spreadsheet to show whats happening and how the sheet is put together. This has got me stumped. Grateful for any further help you can give. |
#5
|
||||
|
||||
Format the cell as General - Select - Hit F2 and Enter
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
Thanks for this.
I tried what you said on the spreadsheet I attached to my previous message and it worked. In order for me to understand fully, can you explain why the problem arose and how your response fixed it? Thanks again for your help. |
#7
|
||||
|
||||
The General formatting option is treated by Excel as a sort of "no formatting" option, so it will often try to guess what specific format you want it in.You can enter anything
If the cell is formatted as text before entering, anything you enter is considered text, even numbers So a formula becomes text and therefore will just sit there waiting. As first the cell must be formatted ( General is default) then edited, followed by Enter, we did it the same way. Change format , edit the cell ( F2 does that) then enter (BTW F2 edits almost everything in MS applications) Why your cell was formatted as Text, I have no idea
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting Issues | Nate1er | Excel | 0 | 11-01-2014 12:21 PM |
Formatting Issues When Using If Statements and Inserting Building Blocks/Autotext | sanko787 | Mail Merge | 1 | 07-05-2014 09:00 PM |
Conditional formatting issues | sjp1966 | Excel | 5 | 02-10-2013 05:42 AM |
Advanced formatting issues | may24 | Word | 2 | 04-21-2010 01:39 PM |
Having some formatting issues after converting PDF to .doc | amf25 | Word | 1 | 06-05-2009 02:05 PM |