Can you perform calculations w/ cells that have both numbers and t


B

BWP

Hi:

I have a cell (A1) that has the following text:

2008 Tipping Fee = $72

I want to perform calculation that reference this 72, and then if I change
the tipping fee, all of the other cells will update. Is there a way I can
make a formula identify just the value in this cell? If not, is there a way
I can hide the input value, in this case, 72, somewhere on the spreadsheet?
- Thank you! BWP
 
Ad

Advertisements

G

Glenn

BWP said:
Hi:

I have a cell (A1) that has the following text:

2008 Tipping Fee = $72

I want to perform calculation that reference this 72, and then if I change
the tipping fee, all of the other cells will update. Is there a way I can
make a formula identify just the value in this cell? If not, is there a way
I can hide the input value, in this case, 72, somewhere on the spreadsheet?
- Thank you! BWP


=MID(A1,FIND("$",A1)+1,99)
 
G

Gord Dibben

I would not use a formula but rather Custom Format A1

Format>Cells>Number>Custom

"Tipping Fee = "$#,##0.00

The just enter 72 or whatever number you wish and reference A1 in your
calculations.


Gord Dibben MS Excel MVP
 
M

Max

Give yourself a break. Keep it simple.
Use Data > Text to Columns to split the text in col A by the delimiter: =
This splits the $ numbers into col B. Then point your calculations to col B.
Hide col B as desired thereafter.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
 
B

BWP

Thank you for all the replies. I used a Custom format in combination with
keeping the 72 value in a distinct cell, it seemed to be the easiest.

Brooks
 
Ad

Advertisements

M

Max

First, thanks for feeding back. Do take a moment to rate all responses which
help by pressing the Yes buttons (like the ones below) from where you're
reading/posting.

Btw, I'd like to clarify that my response implicitly presumes that the data
you mention was already there in col A. And that you were asking for a way to
handle it, all the embedded $$.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top