[Dropped] Keep getting a VALUE message

[JSJOBE24]

On the yearly page, why do I keep getting a value message?

Tattoo's.ods

(13.72 KiB) Downloaded 55 times

[FJCC]

I don't see any #VALUE errors displayed and I can't get any to appear by entering numbers. What causes the error to appear?

[MrProgrammer]

Hi, and welcome to the forum. Thank you for the attachment.

I don't see any #VALUE errors displayed and I can't get any to appear by entering numbers. What causes the error to appear?

I don't see any errors either. JSJOBE24 will get better help if they explain what action causes the error.

On the yearly page, why do I keep getting a value message?

On sheet January, cells in columns E. Q, and U use the DOLLAR function. This function returns text, not a number. Arithmetic operations on text can produce the #VALUE! error. For example if I enter =E3+1 in a cell of that sheet, I get the error. I have no idea what you are trying to accomplish with DOLLAR, but I suspect that you do not want to use this function. In 15 years of helping on this forum I have never seen anyone else use DOLLAR. Why are you using it? There is almost certainly a better way. You won't be able to perform any arithmetic on cells which use DOLLAR.

[Tutorial] Ten concepts that every Calc user should know

[floris v]

On the yearly page, why do I keep getting a value message?Tattoo's.ods

I don't get a value error as well. But you use the =dollar() function from Excel a lot, and =dollar() converts a number to text. When you enter non-zero numbers on the January tab, the numbers don't add up in my ancient Calc on LO 6.x and more recent LO 24.2.