IF Statement

		Microsoft Office Forums > Microsoft Excel > Excel
IF Statement

FAQ

Thread Tools

Display Modes

11-14-2021, 04:30 PM

joeu2004

Windows 7 32bit IF Statement

Office 2007

Advanced Beginner

Join Date: Aug 2016

Posts: 32

I would write:

=IF(OR(A2={"Night","Night (B)"}), B2+1, B2)

Alternatives:

=IF(OR(A2="Night",A2="Night (B)"), B2+1, B2)
or
=IF(LEFT(A2,5)="Night", B2+1, B2)

Caveat: The last formula chooses B2+1 when A2 is __any__ string that begins with "Night". For example, "Night (C)". Do not use it unless you want that flexibility.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting a Select statement in Excel to an update statement	shabbaranks	Excel Programming	5	10-31-2018 11:47 PM
Help with IF statement	kevinU	Excel	0	03-15-2017 02:11 PM
IF statement	mrry475	Excel	1	09-06-2016 09:30 AM
Need a little help with an if statement	cangelis	Excel	2	04-08-2015 05:55 PM
Add a statement	sma	Word	6	03-23-2014 10:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:00 AM.