Microsoft Office Forums - View Single Post - [Solved] concatenate the currency too

Thread: [Solved] concatenate the currency too

View Single Post

Old

12-19-2015, 10:20 AM

isasa74

isasa74 is offline

isasa74 uses Windows 7 64bit

Windows 7 64bit isasa74 uses Office 2010 64bit

isasa74 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Dec 2015

Posts: 12

isasa74 is on a distinguished road

Default

I sorted it out with the following formula :

=IF(ISBLANK(A1),"",CONCATENATE(A2," ",B2," ",C2," ","Price"," ",IF(CELL("format",D2)="C2",TEXT(D2,"$0.00"),TEXT( D2,"€ 0.00"))," ","Freight"," ",IF(CELL("format",E2)=",2",TEXT(E2,"€ 0.00"),TEXT(E2,"$ 0.00"))," ","Duties"," ",F2))

Reply With Quote