How to do checkbox and calculations...

[borisv]

Hello,

I am a very basic user of MS Excel so I don't know almost nothing about functions.

I am working on a simple betting calculator. The functionality I need is:

In E4 is betting ammount. In F4 are odds. In H4 is a result (E4*F4). In J4 there is a checkbox.

So now I need to do when chekbox is TRUE in H4 there is a result (E4*F4), when checkbox is FALSE there is NEGATIVE E4 in field H4...

So when checbox is TRUE that means that bet was won, when FALSE meand the bet was lost and result is negative betting amount.

B.

 

[perimidt]

Try this in H4:
IF(J4,E4*F4,-E4*F4)

 

[borisv]

No luck. I get error... Here is a screen of a situation Screenshot by Lightshot

 

[perimidt]

Hi

Try to use a checkbox from the ActiveX Controls instead:
https://skydrive.live.com/redir?res...uthkey=!AD0ADlmTho3RDuo&v=3&ithint=photo,.jpg

and link it to your cell:
https://skydrive.live.com/redir?res...uthkey=!AICcIbjqsqKM9iQ&v=3&ithint=photo,.jpg