The formula i have is: =(R3*12)-((R3*12)*0.1)

But the problem (or myabe not a problem ) is that i need it to show as
such: $103.57;1;NO;Case Price


I'm not 100% sure that I follow - are there any criteria that determine
what text will follow the value? If not, you can concatenate as
follows:

=(R3*12)-((R3*12)*0.1)&";1;NO;Case Price"

This should do the trick. If there are formulas to determine the 1, NO
and Case Price, then you can connect them using &. The & serves as a
connector - you just have to be sure that any text has " before and
after it. Let me know if you have other questions - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=394807