tick formula

[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

 

[Dave Peterson]

I put my data in A24 (headers in Row 1).

Then put this in E2 and dragged down:

=IF(COUNTA(B22)<>1,"Please check exactly one cell in B",
IF(LEN(B2)>0,A2*2,IF(LEN(C2)>0,A2*3,A2*4)))

(all in one cell)

And I formatted B24 this way:

format|cells|number tab|custom category
In the Type box, I put:

ü;ü;ü;ü

I did this to get it.
alt-0252 (semicolon) alt-0252 (semicolon)....

Use the number keypad (not the numbers above the QWERTY keys).

And use a font of Wingdings.

Now anything you type into one of those cells will look like a checkmark.