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 Jito4632007-05-09 08:45:24
  "#######" usually indicates a too small cell by anymouse2007-05-09 08:50:10
    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 Jito463 2007-05-09 09:04:59
I was trying to incorporate those same formulas from the other cells so it wouldn't have to reference those cells for the final total and just come up with it all from within that one cell. I just got #Value! instead. The formula was:

=SUM(100/(B3:B33))*((22*8)*C37)

More than a bit convoluted, yes. But if it got the job done I was willing to live with it. Unfortunately, it didn't.

I also tried mixing the last formula around a bit (C37*(22*8)), but that didn't work either.
[ Reply ]
            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

 

[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.)