J
jossfrimond
Here's a tricky one, and yes, I have done a search!!
I have five columns, the first being simple data, the next thre
including variables, and the fourth being the solution.
I would like to be able to use ticks in cells of three variabl
columns. You can only tick ONE of those cells at a time, not two o
three simultaneously. If one is ticked, this would mean that a formul
would be calculated, and a result would be displayed in the fourt
column's cell. So, to give a simple example:
CELL A CELL B CELL C CELL D CELL E
data cell a X 2 cell a X 3 cell a X 4 Answer
eg
CELL A CELL B CELL C CELL D CELL E
3 empty empty ticked 12
5 empty ticked empty 15
3 ticked empty empty 9
Can anybody help me use those ticks with an underlying formula? Thi
sheet would be for employees to tick off according to work hours done.
Thanks
Joss Frimon
I have five columns, the first being simple data, the next thre
including variables, and the fourth being the solution.
I would like to be able to use ticks in cells of three variabl
columns. You can only tick ONE of those cells at a time, not two o
three simultaneously. If one is ticked, this would mean that a formul
would be calculated, and a result would be displayed in the fourt
column's cell. So, to give a simple example:
CELL A CELL B CELL C CELL D CELL E
data cell a X 2 cell a X 3 cell a X 4 Answer
eg
CELL A CELL B CELL C CELL D CELL E
3 empty empty ticked 12
5 empty ticked empty 15
3 ticked empty empty 9
Can anybody help me use those ticks with an underlying formula? Thi
sheet would be for employees to tick off according to work hours done.
Thanks
Joss Frimon