Is there a way to default a cell so that if you enter a number into it, it will automatically calculate a different number.
So for example lets say I want to enter a number to convert seconds into minutes.
Typically you could just create an equation for that, but I was wondering if you could "program the cell" to return a value according to a predefined equation.
(I had a look under format cells but I dont know if divide operator works in there or not).
TIA
So for example lets say I want to enter a number to convert seconds into minutes.
Typically you could just create an equation for that, but I was wondering if you could "program the cell" to return a value according to a predefined equation.
(I had a look under format cells but I dont know if divide operator works in there or not).
TIA
