# How do I make this an either/or formula?

#### basicusa

##### New Member
How do I make this to solve if C792=26 or if C792=24 ?

=IF(\$C792=26,+IF(\$G792=DF\$2,+\$E792,""),"")

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### ken2step

##### Well-known Member
=IF(OR(\$C792=26,\$C792=24),\$E792,"")

#### Brian from Maui

##### MrExcel MVP
basicusa said:
How do I make this to solve if C792=26 or if C792=24 ?

=IF(\$C792=26,+IF(\$G792=DF\$2,+\$E792,""),"")

IF(OR(\$C792={24,26}),\$C792+\$E792,"")

Replies
1
Views
78
Replies
1
Views
98
Replies
2
Views
96
Replies
3
Views
105
Replies
6
Views
72

1,181,791
Messages
5,932,066
Members
436,817
Latest member
Fatoux

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