Solved How do I fix formula export error from Google Sheets?

March 10, 2019 at 19:56:47
Specs: Windows 7, 4.0GHz
So I am trying to copy this RPG character sheet that calculates ability scores for you, to my PC.
https://docs.google.com/spreadsheet...

Everything works except the calculation for Hit Points after exporting.

When I saved to my HD and went open it with Office 2013, it said something about something might not work right. Anyway here is the value that supposed to calculate for Hit Points:

The value is: =8+ConMod+(4+ROUNDUP(ConMod/2))*(Level-1)

No matter what I try it won't work now. It keeps saying it's too few arguments.


See More: How do I fix formula export error from Google Sheets?

Reply ↓  Report •

#1
March 10, 2019 at 20:37:16
✔ Best Answer
ROUNDUP() requires two arguments. You're providing one. Try:
=8+ConMod+(4+ROUNDUP(ConMod/2, 0))*(Level-1)

How To Ask Questions The Smart Way


Reply ↓  Report •

#2
March 10, 2019 at 20:44:46
Holy !#$#! it worked!

Thank you SOOO much!


Reply ↓  Report •
Related Solutions


Ask Question