Sheet wont add up anything past $999.99

Forum|Forum|2 years ago
January 18, 2024
1 reply
1726 views

I will do my best to explain this but its complicated

I have an expense sheet that has multiple cells in a row that are calculated and extended right, that works, it adds up four cells and does a calculation to dive the GST in half, all good. However, to add up the entire sheet with the full GST I am adding up the sum of multiple rows. if I get to a point in the sheet where the total adds up to anything more than $999.99 it returns this in the box $1.#R if i click on that total box, it shows me the actual $ amount, but as soon as i click out of it all i can see is that error code above.

Help?

General troubleshooting

This topic has been closed for replies.

Nesa Nurani

Community Expert

Do you use any format script in that field?

Dorothy26138473siqlAuthor

Known Participant

Yes, to make it so the $0.00 doesnt show until something is added into that cell. However, I deleted the script and the problem still exists.

Calculation is as follows: just adding up three fields. (which are sums of other longer fields, i think 12 rows i have in each so this sheet can get quite large its for expenses.

Value of sum field is kmtotal, mealstotal, rectotal

Validation Script

if((event.value == 0) || isNaN(event.value) || (event.value == Infinity))
event.value = "";
else
event.value = util.printf("$%,0.2f",event.value);

Nesa Nurani

Community Expert

Did you try removing 'else' part from the script and format field as number?

If that doesn't help, post your file.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded