Question about Microsoft Windows XP Home Edition

1. enter = symbol

2. enter ( symbol

2. enter cell location where your cost value is

3. enter * symbol

4. enter 0.7

5. enter ) symbol

6. enter 0.175

eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Posted on Oct 08, 2008

When you open Office 2003 files with Office 2007, it works in compatibility mode, so that if you open the files in earlier version (i.e. Office 2003 etc) there would be no issues (reverse compatibility with earlier versions.

Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.

So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH

Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.

So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH

May 16, 2011 | Operating Systems

Hide All

Percentages are calculated by using the following equation:

amount/total = percentage

Where percentage is in decimal format.

What do you want to do?

Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.

Example
The example may be easier to understand if you copy it to a blank
worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?

Example The example may be easier to understand if you copy it to a blank worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Simple way Amount/Total*100

Apr 30, 2011 | Operating Systems

Parts of the Excel 2007 Screen

Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx

http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx

http://support.microsoft.com/kb/820741?wa=wsignin1.0

Nov 02, 2010 | Operating Systems

If you open an excel created by M/S Office 2007, Excel 2003 will not be able the file. You have to install Microsoft Office the "Compatibility Pack for Word, Excel, and PowerPoint File Formats" for M/S Office 2003 from Microsoft Site.

or

Your Excel file is corrupt!

Hope it helps.

or

Your Excel file is corrupt!

Hope it helps.

Oct 01, 2010 | Operating Systems

Convert to UPPER, Proper or lower

Auto Convert to UPPER, Proper or lower

Stop VBA Being Case Sensitive

Select Case Statement. Great alternative to Else If Statements

VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().

dDate=cDate("25-Jan-07")

Convert Numbers to Words

Convert Numbers to Dollar Amount in Words

Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $

SQL Database Migration $

Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $

CSV Converter $

Import SQL Into Excel-SQL Tester $

Import Excel Into Access $

Conditional Formatting

More Than 3 Conditional Formats

Conditional Format Fonts for greater than 3

Custom Formats

Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like

To hide zeros on the Workbook level go to

Dec 15, 2008 | Microsoft Windows XP Home Edition

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

Read the fine manuals.

Jun 06, 2008 | Microsoft Windows XP Professional

add the correct formula to count the column and or rows

May 27, 2008 | Microsoft Windows Vista Ultimate Edition

THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

110 people viewed this question

Usually answered in minutes!

it was probably me but i couldn't get the formulae to work

×