The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Excel question by Jito463 2007-05-09 08:45:24
Ok, so I've got two different numbers in different cells. Say, A1 = 10,000 and B1 = 3,000 for example. I want to have another cell show me what percentage B1 is of A1 (in this case, 30%). Here's what I tried so far:

=SUM(100/A1)*B1

and

=SUM(100/A1*B1)

Now, when I perform this calculation on the calculator (100 divided by 10,000, take that sum times 3,000), it shows 30 as one would expect. But when I do it in Excel I get ####### displayed (no matter what the format for numbers is set to). Anyone have any ideas on how I would go about this? I cheated for now and made a seperate cell (we'll call it A2) with white text showing:

=SUM(100/A1)

Then another cell with

=SUM(A2*B2)

to get the final total, but this is a hack workaround. Anyone know a way to do this in a single cell?
[ Reply ]
  "#######" usually indicates a too small cell by anymouse2007-05-09 08:50:10
    s/lesser/fewer/ ;-) (n/t) by AndyA2007-05-09 08:52:56
      DD by anymouse2007-05-09 09:30:38
    Duh, thanks. However.. by Jito4632007-05-09 08:54:17
      Hmm, maybe it's because by Jito4632007-05-09 08:56:32
        Forgot to mention by Jito4632007-05-09 08:57:23
          Nope, that didn't work by Jito4632007-05-09 09:04:59
            What are you trying to do exactly? by AndyA2007-05-09 09:09:55
            *points to previous post* by fiordhraoi2007-05-09 09:13:46
              *facepalm* by Jito4632007-05-09 12:07:53
  You don't need the SUM function by fiordhraoi2007-05-09 08:53:19
    Common misconception there, by jeff_uk2007-05-09 09:18:02
      Misuse of average? What do you.... *cough*...mean? (n/t) by poolya2007-05-09 09:20:10
    Aye - that's a pet peeve of mine. by poolya2007-05-09 09:18:15
      for reference, SUMPRODUCT is useful too :) (n/t) by jeff_uk2007-05-09 10:24:55
  =B1/A1     (That's all you REALLY need) by inittab2007-05-09 09:33:31
    Doesn't work by Jito4632007-05-09 12:04:35
    Never mind, you were right by Jito4632007-05-09 12:09:09

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)