Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-20-2015, 04:09 AM
stuwoolf stuwoolf is offline Using IF Statements and Formatting Issues Windows 8 Using IF Statements and Formatting Issues Office 2010 64bit
Novice
Using IF Statements and Formatting Issues
 
Join Date: Dec 2014
Posts: 14
stuwoolf is on a distinguished road
Default 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.
Reply With Quote
 



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
Using IF Statements and Formatting Issues 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft