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.

Kind regards,
Regina

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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