concatenate the currency too

		Microsoft Office Forums > Microsoft Excel > Excel Programming
concatenate the currency too

FAQ

Thread Tools

Display Modes

12-19-2015, 10:20 AM

isasa74

Windows 7 64bit concatenate the currency too

Office 2010 64bit

Novice

Join Date: Dec 2015

Posts: 12

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))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
how to concatenate text box on new slide	wichitawx	PowerPoint	5	05-19-2015 05:17 AM
Concatenate with @ symbol	anickles	Excel	2	02-06-2015 09:39 AM
Concatenate if in descending order	pgeorgilas	Excel Programming	2	12-10-2014 01:35 AM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM

Other Forums: Access Forums

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