Excel Formulas... HELP

G

ginkle7

New Member
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 Computer

System One


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 Computer

System One

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 Computer

System One

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 Computer

System One

  • CPU
    Dual L5639 // i7 950 @ 4.0Ghz
    Motherboard
    Evga SR-2 // Gigabyte x58a-ud3r
    Memory
    12Gig Corsair XMS3 // 6Gig OCZ Gold
    Graphics Card(s)
    gtx 560 ti // gtx 260-216
    Monitor(s) Displays
    Dual 22" // Headless
    Hard Drives
    OCZ aGILITY 3, 120Gig + Seagate 500Gig x 2
    PSU
    Silverstone da700 // Corsair 520hx
    Case
    Rosewill BlackHawk Ultra // Antec 900v1
    Cooling
    Twin CM Hyper 212+ // Noctua NH-u12
    Other Info
    Acer 8930 laptop with x9100...
You must log in or register to reply here.
Back
Top