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.
Kind regards,
Regina
--
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
