We have recently reorganized the forums to better accommodate the location of information. If you find any discussions categorized incorrectly please let us know and we will get it sorted out.

ZombieRob71
FL

Hiya folks. I was messing around with a homemade character sheet/generator and I'm trying to figure out the formula for calculating the sum of two numbered cells, each one having been /10 to calculate their tens digits as singles, and then rounded down. I was wondering if anybody out there had such knowledge as "how" to write the formula.

An example would be numbered cells 32 & 28

=SUM(ROUNDDOWN(C4/10,C6/10),2)

I got 5.2 with this. Not sure how to make it simply 5 ;)

Most Excel Help sites want to charge you $40 just to answer LOL.

Cue my cry for help ;)

Much thanks!

## Comments