Author Topic: Windows Excel...  (Read 2326 times)

0 Members and 1 Guest are viewing this topic.

Offline Kalashina Manahsyane

  • Insane Story Writer
  • Administrator
  • ******
  • Yes?
  • Posts: 387
  • Karma: +0/-0
  • Ryu of the Wilds
    • View Profile
    • Dyhokan Emporium
Windows Excel...
« on: June 01, 2010, 11:30:45 PM »
Don't suppose anyone has ever used this before? What I'm asking is this:

For the clan I'm apart of, I am creating an excel sheets that makes it easier for the squads to calculate their ship upkeep. It's for a game where EACH ship has upkeep of some type.

In this case, the second to last two values displays the number of ships of that class, along with the ships indivisual upkeep. The last value is supposed to times the first upkeep number by the number of ships it has.

Example:

Number value is two
Upkeep value is four million
Total Value is eight million

I want the excel sheet to auto-calculate that but I don't know HOW to get it to do that :(

Offline Slaskia

  • Sangheili fanatic
  • Administrator
  • ******
  • Posts: 160
  • Karma: +0/-0
    • View Profile
Re: Windows Excel...
« Reply #1 on: June 02, 2010, 08:40:20 AM »
It's done with formulas.  Unfortunately, that aspect of Excel is my weakest when it comes to working with it.

Offline Mifune Fuji

  • Neko or Kitsune?
  • Photonic Moderator
  • *****
  • Sciora, Lancer
  • Posts: 195
  • Karma: +0/-0
  • Foxgirl Loving Maniac!
    • View Profile
    • ShadowHime
Re: Windows Excel...
« Reply #2 on: June 02, 2010, 11:52:10 AM »
Like Slaskia, I've not done anything with formulas in Excel (or any spreadsheet program). Could try using the almighty Google perhaps. =P I'm sure there are a good handful of tutorials online somewhere. (school sucked, so I could never get into any sort of classes that dealt with it)