Microsoft Office Forums - View Single Post - Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement

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

View Single Post

Old

04-12-2017, 04:27 PM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 533

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

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.

Reply With Quote