# if formula

##### Board Regular

A2 = 0 B2= 1

C2= IF(A2>0,B2>0,0,1)

result wanted
A2= 0 B2=0 C2 ??? 0
A2= 0 B2=1 C2 ?? 0
A2= 1 B2= 0 c2 ?? 0
A2= 1 B2= 1 c? A2+b2

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### Weaver

##### Well-known Member
Try

=IF(AND(A2,B2),2,0)

Assuming A2 and B2 will only ever be 0 or 1

or

=AND(A2,B2)*2

#### Andrew Poulsom

##### MrExcel MVP
Maybe:

=IF(OR(A2=0,B2=0),0,A2+B2)

##### Board Regular
thx all of you it's working

Replies
6
Views
444
Replies
6
Views
354
Replies
5
Views
212
Replies
3
Views
627
Replies
4
Views
341

1,191,371
Messages
5,986,264
Members
440,015
Latest member
knijgh

### 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