Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula in text boxes
I have heard you can put string arithmetic formula in text boxes. How do
you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will |
#2
|
|||
|
|||
A text box can contain a cell reference --
Enter the formula in a cell on the worksheet Create a text box. Click on the text box to select it Click in the formula bar, and type an equal sign Click on the cell that contains the formula Press the Enter key Will Fleenor wrote: I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi Will,
I thought I recognized you name from somewhere so I googled you and figured out you're with K2. We've never met, but I've enjoyed various presentations by Dr. Bob Spencer and Randy Johnson. Keep up the good work! Mike. "Will Fleenor" wrote in message ... I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will |
#4
|
|||
|
|||
Thanks, that works but apparently you can only build references to a single
cell and can not build a formula. Ex. you can have =A10 but not =A10+B10. Is this correct? Thanks, Will "Debra Dalgleish" wrote in message ... A text box can contain a cell reference -- Enter the formula in a cell on the worksheet Create a text box. Click on the text box to select it Click in the formula bar, and type an equal sign Click on the cell that contains the formula Press the Enter key Will Fleenor wrote: I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
That's correct.
Will Fleenor wrote: Thanks, that works but apparently you can only build references to a single cell and can not build a formula. Ex. you can have =A10 but not =A10+B10. Is this correct? Thanks, Will "Debra Dalgleish" wrote in message ... A text box can contain a cell reference -- Enter the formula in a cell on the worksheet Create a text box. Click on the text box to select it Click in the formula bar, and type an equal sign Click on the cell that contains the formula Press the Enter key Will Fleenor wrote: I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
All changes (formula additions)within the referenced cell
are reflected in the text box, which is handy. BUT here is an interesting observation... I was able to bold the contents of the text box by bolding the cell I referenced, only once though. If that was at possible, does anyone know how it could be duplicated? As formating linked to the text box would be extremely useful any ideas would be appreciated? TIA -----Original Message----- That's correct. Will Fleenor wrote: Thanks, that works but apparently you can only build references to a single cell and can not build a formula. Ex. you can have =A10 but not =A10+B10. Is this correct? Thanks, Will "Debra Dalgleish" wrote in message ... A text box can contain a cell reference -- Enter the formula in a cell on the worksheet Create a text box. Click on the text box to select it Click in the formula bar, and type an equal sign Click on the cell that contains the formula Press the Enter key Will Fleenor wrote: I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
#7
|
|||
|
|||
That looks right, but you could put a compound formula in the cell being
referenced to, such as A30:=A10+A20, and use A30 in the textbox. -- HTH RP (remove nothere from the email address if mailing direct) "Will Fleenor" wrote in message ... Thanks, that works but apparently you can only build references to a single cell and can not build a formula. Ex. you can have =A10 but not =A10+B10. Is this correct? Thanks, Will "Debra Dalgleish" wrote in message ... A text box can contain a cell reference -- Enter the formula in a cell on the worksheet Create a text box. Click on the text box to select it Click in the formula bar, and type an equal sign Click on the cell that contains the formula Press the Enter key Will Fleenor wrote: I have heard you can put string arithmetic formula in text boxes. How do you do this? For example I would like to add the contents of three cells as follows: =B1&DOLLAR(B3,2)&B2 Thanks Will -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
How can I delete ALL text boxes in Excel worksheets? | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Text Boxes | Excel Discussion (Misc queries) |