conditional cell value reset [closed]

asked 2014-05-29 21:59:53 +0100

zlyuk13 gravatar image

updated 2015-09-05 20:44:16 +0100

Alex Kemp gravatar image

In LibreOffice 3.5.7.2 Calc, I would like to achieve is to add some sort of reset button that would erase values of groups of cells when pressed or for example if certain cell has a specified value then reset values of specified cells (eg erase values). I was thinking =IF() function but have no idea what parameters has to be passed in to it.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-23 21:47:43.878919

Comments

Could you please explain in more details and give examples?

ROSt52 gravatar imageROSt52 ( 2014-05-30 02:39:24 +0100 )edit

For example I have cells range in a rows A to C in column 1, therefore 3 cells {A1,B1,C1} I would like to be able to set values within these cells ether equal to 0 or to Nill, through entering some specific value such as true or false in to cell (for example D1). Is there are a formula to achieve that. However my initial goal is to find out if there are some analogies of "buttons" in Lo calc that support mouse clicking to perform actions that would be same as entering True or False in to D1.

zlyuk13 gravatar imagezlyuk13 ( 2014-06-03 14:43:15 +0100 )edit