using option buttons

[lezawang]

Hi
I inserted 4 option buttons in a sheet (developer-->insert). I linked them to cell K1
Now when i click on the first one then K=1, second one, then K=2 etc.
So far so good. I wrote this formula in L1

L1 = if (K1=1, N1=1,N1=100)

So I want to make the value of cell N1 = 1 if K1 is 1, how can I do that? Now I am getting FALSE in cell L1!
Thank you very much.

 

[Fluff]

A formula can only affect the cell it's in.
So if you want to display 1 in N1, then you will need to put the formula in N1

 

[lezawang]

I wrote this formula in L1 =IF(K1=1,L1=100,L1=200) but it always give me 0.
K1 value is changing from 1 to 4 depends on which option i clicked but still 0
Thank you.

 

[Joe4]

As Fluff saif, a formula can only ever return a value to the cell it is located in, so you do not need to designate which cell it goes in.
Just put this formula in cell L1:

[COLOR=#333333]=IF(K1=1,100,200)[/COLOR]