Hi, new the the forum.... :)
I needed some help regarding formulas and text in one cell. What i'm
trying to do is develop a simple formula to calculate a simple number.
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

Is it possible to have a formula and text in the same cell, if so, how?


Any help would be appreciated. Thanks.

Saurabh


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