If Or formula

A

alvbnp

Board Regular
Joined
Jun 26, 2006
Messages
180
How can I make this into formula?

If a1=b1 or a1=c1, "ok", "not ok"

Thanks.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

PuntingJawa
  • Solved
Nested formula with multiple criteria
Replies
7
Views
159
PuntingJawa
PuntingJawa
X
  • Question
Need help
Replies
3
Views
78
etaf
etaf
M
  • Solved
Tell me the status based on a percentage
Replies
3
Views
124
etaf
etaf
Trevor3007
  • Question
if both a1 & b1 are not blank, then insert a '1' into cell c1
Replies
6
Views
184
Fluff
Fluff
D
  • Question
Correctly Write Formula For Time < 59 Minutes
Replies
6
Views
145
Fluff
Fluff

Forum statistics

Threads
1,215,786
Messages
6,126,891
Members
449,347
Latest member
Macro_learner

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top