Search : in
By :

Percentage formula for microsoft excel

Last answer on Jun 26, 2009 2:36:14 am BST Dougie, on Jun 25, 2009 8:25:46 pm BST 
 Report this message to moderators

Hello,
Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ,my cost total is in cell I40 and in I41 im trying to add a 20% mark up figure of the total in I40 can anyone help

Configuration: Windows XP Internet Explorer 8.0

Best answers for « percentage formula for microsoft excel » in :
Keyboard /Mouse Tips for Excel ShowKeyboard /Mouse Tips for Excel Intro Other Shortcuts Intro Excel tutorials give hints that make the difference between a needy use and flexibility. Here are some examples: Copy the highlight to the clipboard: [Ctrl + Ins] Paste...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 venkat1926, on Jun 26, 2009 2:36:14 am BST
  • +5

I presume what you mean by 20% mark up figure is 20% more of the value in the cell I40

in the cell I41 type the formula
=I40-1.2

   
Reply to venkat1926
Ask your question Reply
They need your help