Windows Vista Forums

Excel Formulas... HELP
  1. #1
    ginkle7's Avatar

    Newbie
    Join Date : Jul 2012
    Posts : 2
    Vista Home Permium 32bit
    Local Time: 08:47 PM

    Excel Formulas... HELP

    I NEED HELP BAD on formulas in excel for Vista. Trying to make a spreadsheet of percentages off a total amount.
    Example: in cell A... any # I key in it will x # by 2.8%= total in cell A. then cell B is cell A total x 17%= total in cell B x 18%= total in cell C= total in cell C x 65%=cell D

    This will happen no matter what # I key into cell A. It will auto cal cell ABC&D

    A x 2.8% B x 17% C x 18% D x 65%




    I hope someone can understand what I am trying to do. HELP PLEASE ASAP!!!!

      My System SpecsSystem Spec

  2. #2
    ululator's Avatar

    Member
    Join Date : Oct 2008
    Posts : 37
    Vista Home Premium 64bit
    Local Time: 09:47 PM
    usa us florida

     

    Re: Excel Formulas... HELP


    Hi Ginkle,
    I can’t tell why Excel is auto calculating without more info. What were you originally trying to calculate?
    Also, I would need to see what formulas you’re using. Could you submit a screen shot with formulas displayed?

    HOW TO DISPLAY FORMULAS:
    Press CTRL + ` (grave accent).
    To switch back to hidden formulas: Press CTRL + ` (grave accent) again.

    Fortunately, Excel is easy to work with, so it should be a simple fix


      My System SpecsSystem Spec

  3. #3
    ginkle7's Avatar

    Newbie
    Join Date : Jul 2012
    Posts : 2
    Vista Home Permium 32bit
    Local Time: 08:47 PM


      Thread Starter

    Re: Excel Formulas... HELP

    If you have an email address I can email you a better example and maybe explain better.

    Thank You

      My System SpecsSystem Spec

  4. #4
    ululator's Avatar

    Member
    Join Date : Oct 2008
    Posts : 37
    Vista Home Premium 64bit
    Local Time: 09:47 PM
    usa us florida

     

    Re: Excel Formulas... HELP

    Hi Ginkle,
    It probably would be easier if I could actually see your original Excel worksheet. Fortunately, you can attach your entire Excel document to a forum post.

    To attach a file to a new post, simply click the MANAGE ATTACHMENTS button at the bottom of your Reply (DON’T use Quick Reply.)
    Locate the file that you want to attach from your local hard drive, & upload it.

    Don’t forget to include a description of exactly what you were trying to calculate in the first place. If you feel it’s too much to get into in a forum post, write it all out in a (saved) Word document. Then upload that as well.


      My System SpecsSystem Spec

  5. #5



    Senior Member



    Join Date : Jul 2010
    Posts : 1,998
    Ultimate x64, home Prem 64
    Local Time: 09:47 PM
    canada

     

    Re: Excel Formulas... HELP

    This sounds like home work for summer school...

    in cell A1 put your number
    in cell A2 put =a1*.0028
    in cell a3 put =a2*.017
    etc

    When you type = it sets itself as a formula, if you click the cell you want, i.e. A1 it'll put it into thde formula, then fisish typing your formula.

    Here, youtube it
    Excel 2010: Simple Formulas - YouTube

      My System SpecsSystem Spec

Excel Formulas... HELP problems?

Similar Threads
Thread Thread Starter Forum Replies Last Post
MSOutlook.info. Quickly set dates with formulas and text. JMH Microsoft Office 0 14 Sep 2009
running Excel Macro in in specified Excel files in spe Observer PowerShell 0 03 Apr 2009
Strange problem writing Excel formulas using .NET John Brock .NET General 4 28 Aug 2008
How to view Excel document without Microsoft Office Excel installe jl Vista General 8 20 Apr 2008
Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object ckellywilson Microsoft Office 0 26 Mar 2008