# How to do checkbox and calculations...

#### borisv

##### New Member
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.

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### perimidt

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

Replies
2
Views
132
Replies
2
Views
235
Replies
1
Views
152
Replies
10
Views
332
Replies
10
Views
866

1,196,027
Messages
6,012,954
Members
441,740
Latest member
abaz21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back