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.
Could you please explain in more details and give examples?
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.