![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
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 |
![]() |
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 |