Pergunte aqui

Perfil de MDC - atividade

2018-03-10 18:07:45 +0200 Medalha recebida  Autodidata (fonte)
2018-03-10 18:07:45 +0200 Medalha recebida  Professor (fonte)
2018-03-10 17:56:22 +0200 Medalha recebida  Estudante (fonte)
2018-03-10 17:56:19 +0200 Medalha recebida  Pergunta popular (fonte)
2018-03-10 17:56:19 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-03-10 17:56:19 +0200 Medalha recebida  Pergunta notável (fonte)
2017-03-15 05:17:30 +0200 Resposta comentada Calc will not use 'rounded up/down' numbers in formulas

No Problem Lupp. Thanks for following up with me. I did see your comment, but please forgive me and my ignorance, I really did not get it. I have yet to find the necessary "Preferences" on my Mac either. I am sure it is here somewhere since you say it is.... I am just not fining it.

2017-03-11 02:43:00 +0200 Resposta comentada Calc will not use 'rounded up/down' numbers in formulas

Lupp, I am really sorry about the "loud" writing. I was as surprised as you must have been. I even went back to attempt to change/edit it but could not. I have no idea why/how that happened. I will continue to look for the 'Preferences'. I would still like to know where karolus was able to come up with =INT, so perhaps in the future I will not have to be quite so ignorant :-). Again I apologize for the loud writing, I hope this one does not come out that way.

2017-03-11 02:38:27 +0200 Medalha recebida  Entusiasta
2017-03-10 02:34:46 +0200 Resposta comentada Calc will not use 'rounded up/down' numbers in formulas

Thank You Lupp for your assistance. I am using a Mac, and I am still not finding the 'Options' (or Preferences) under tools. I am not sure what 'UI' is, so maybe that is where I am missing it.

on another note, I "just now" saw the comment from you Karolus, =INT( G4/2000 ), I tried it and it worked perfectly. Thank you! Please tell me if you can though, what is the INT, and how could I have known this or found it, for future reference or problems? Thanks again

2017-03-08 23:34:55 +0200 Resposta comentada Calc will not use 'rounded up/down' numbers in formulas

If you are referring to this: →Tools→Options→LO-Calc→calculate→[x]precision as shown , thank you. However, I am not finding Options under tools. Could I be looking in the wrong place? I believe this is your answer...Work with 2digit precision-formatting on Currencies and use appropriate precision otherwise... but I don't know how to use it. Forgive my ignorance, I appreciate your attempt to help me. Lupp.... your sarcasm is not at all helpful.

2017-03-08 05:48:40 +0200 Resposta comentada Calc will not use 'rounded up/down' numbers in formulas

Thanks for the comments. Looks like I "accidentally" answered instead of 'commented'. Meanwhile, could you guys please tell me how to accomplish the task I am attempting?

2017-03-07 07:17:50 +0200 Respondeu uma pergunta Calc will not use 'rounded up/down' numbers in formulas

Thanks so much for the quick response. You are correct, I was 'reducing decimal places'. So, please forgive my ignorance in how to get around this software, where everything is and what it is called. I am a novice at it, I only know what I want it to do.
The issue is this: I need to cell E5 to = G4/ every 2000 that is in cell G4. So, if G4 is 3500, then cell E5 still needs to be 1, not anything more, since 2000 only goes into 3500 once. Once cell Gx is over 4000 then cell Ex can go to 2, etc.

Does that help at all?
Can you tell me how to accomplish this? Thanks in advance

2017-03-06 23:18:43 +0200 Perguntou Calc will not use 'rounded up/down' numbers in formulas

The formula I am needing is based on the rounded 'up/down' number. Calc. will display the rounded number, however, it uses the original number (from before it was rounded) in the calculation of the formula being used in the cell. This ruins the calculation. Is there a way to change this?