Microsoft Office Forums - View Single Post - [Solved] How to combine these formulas into one?

Thread: [Solved] How to combine these formulas into one?

View Single Post

Old

12-26-2017, 02:06 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2003

LearnerExcel uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

Got it.

Code:

=CONCATENATE(IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$D2),"",[PurchaseStatementTemplate.xls]Sheet1!$D2),IF(ISBLANK([PurchaseStatementTemplate.xls]Sheet1!$E2),"",[PurchaseStatementTemplate.xls]Sheet1!$E2))

Reply With Quote