Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas in a cell
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
How come my formulas work in one cell but not the other? | Excel Worksheet Functions | |||
Need formulas for adding feet, inches & fraction in one cell | Excel Worksheet Functions |