Excell Noob Question

Soldato
Joined
8 Dec 2004
Posts
15,048
Location
Hampshire
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 :)
 
I don't know how to do exactly what you're asking, but I would:
Insert a new column.
In the cell next to your current cell (containing seconds) I would put "=A4/60" and then use the small black "copy down" square to fill the column with it.
 
I don't know how to do exactly what you're asking, but I would:
Insert a new column.
In the cell next to your current cell (containing seconds) I would put "=A4/60" and then use the small black "copy down" square to fill the column with it.

Yea thats the usual way of doing it and what I was doing before, but was just curious if you can default a cell to do a predetermined calculation.
Thanks anyway. Does anyone know if this is possible?
 
Back
Top Bottom