*From:* Regina Henschel <[email protected]>
*Sent:* Monday, September 15, 2025 at 8:03 AM EDT
*To:* [email protected]
*Subject:* RE: [libreoffice-users] Change a value given a condition?
Hi Craig,
Craig Lister schrieb am 14.09.2025 um 03:42:
If the numeric value in cell A1, that has a formula in it, is
negative then I need the number in cell B1 to have 360 added to it.
Any idea how to accomplish this?
Without macro you cannot push a value to a cell. But the target cell
collects it information from the other cells. So if the value in cell
B1 depends on cell A1, then you need to write an according formula in
cell B1.
If currently the cell B1 has a formula or constant number `N`. Then
you can change that to =if(A1<0; N + 360; N);
What it the content of cell B1 currently? Are you calculating angles?
It might be, that there exists a total different solution. But to be
able to judge that, you would have to provide more context.
Regina, you're correct- I'm working with angles and will give your
formula a try.
Thank you,
Craig
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
