Tick a box returns a "true" value

[bring32]

Hi all,

New to the forum hope you don't mind me asking question without contribution (yet)

My college created me a template but its an prototype and I wish to finish it while he is on holiday

I'm stuck at a tick box function, where you tick a box it returns a "true" value

For example
Cell A1 is a title, a text
Cell A2 has a little box that you can tick
Cell A3 returns a "true" or "false" value depends whether you tick that box or not.

In cell A2, There is a formula: if(A3=TRUE, A1, 0), I believe the returned value is to be used for Sumifs in other area which might have nothing to do with this tick box I'm wondering

Can anyone shade some lights how this is done?
Could it be conditional formatting?

Thanks in advacne

 

[magpie2000k]

select cell 3 then crtl and selct the tick box then type in formula bar =click a3

this will return true in A3 is tick box is ticked and false if it is not.

Is that what you are asking?

 

[bring32]

Thanks heaps Magpie it worked!
When Ctrl +A2 (where the tick box is), its referencing to A3, which is why when I tick A2, A3 returns a value of TRUE

 

[bring32]

One more question if possible

I'm trying to copy&paste for at least another 50 tick boxes, and each tick box needs to reference to different cell

However when I paste, every single box has a formula of =A3, Is there a way to avoid absolute value

Sorry literally first time playing tick box

 

[magpie2000k]

I am not sure copying and pasting is possible with tick boxes maybe one of the others can answer that.
When I try and do as you suggest it duplicates the formula so when I tick one it only edits A3

I will keep trying I am not an expert just had done what you were asking before.

If you right click on teh tick box in question you can select format control and change the cell it references.

Not the quickes way but doable.