Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement

		Microsoft Office Forums > Microsoft Excel > Excel
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement

04-12-2017, 04:27 PM

Logit

Windows 10 Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Paste in AG9, then copy down the column as required.

Code:

=IF(AB9="y","",IF(AC9="n",Y9,""))

This presumes either AB9 or AC9 will have a value, but not both at the same time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help! figuring if statement with 2 vlookups excel 2013	MWATKINS7111	Excel	3	02-24-2017 12:58 AM
Excel (2016) Hangs	dave1510	Excel	0	05-11-2016 12:31 PM
Constructing a detailed Timeline	maccapacca	Project	1	08-29-2013 04:55 AM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
help constructing a TRAVEL jOURNAL	peterseaford	Word	2	05-23-2010 02:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.