| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add a cell reference to the start of a formula
my cell is custom formatted to read, "## "min. =" $##.##"
my formula is =FIXED(D30/60,3)*F28 the cell reads min. = $19.49 what i'm missing is the number of minutes, which is displayed in cell F28. so i just need to reference that cell at the start of my formula. the question is how?! thanks for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a cell reference to the start of a formula
Excel won't split up a value into the formatting "parts" ## and $##.## - you
need to do the whole thing in the formula: =F28&" min. = "&TEXT(FIXED(D30/60,3)*F28,"$##.##") HTH "h." wrote: my cell is custom formatted to read, "## "min. =" $##.##" my formula is =FIXED(D30/60,3)*F28 the cell reads min. = $19.49 what i'm missing is the number of minutes, which is displayed in cell F28. so i just need to reference that cell at the start of my formula. the question is how?! thanks for any help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a cell reference to the start of a formula
perfect! thanks that worked, except now any cells referencing this cell read
"value" because there are two values. how can i tell it to choose just one? eg: 18 min. = $19.49 i want a cell to read $19.49 only. "Bob Umlas, Excel MVP" wrote: Excel won't split up a value into the formatting "parts" ## and $##.## - you need to do the whole thing in the formula: =F28&" min. = "&TEXT(FIXED(D30/60,3)*F28,"$##.##") HTH "h." wrote: my cell is custom formatted to read, "## "min. =" $##.##" my formula is =FIXED(D30/60,3)*F28 the cell reads min. = $19.49 what i'm missing is the number of minutes, which is displayed in cell F28. so i just need to reference that cell at the start of my formula. the question is how?! thanks for any help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a cell reference to the start of a formula
Try this:
A1 = 18 min. = $19.49 =--MID(A1,FIND("$",A1)+1,100) -- Biff Microsoft Excel MVP "h." wrote in message ... perfect! thanks that worked, except now any cells referencing this cell read "value" because there are two values. how can i tell it to choose just one? eg: 18 min. = $19.49 i want a cell to read $19.49 only. "Bob Umlas, Excel MVP" wrote: Excel won't split up a value into the formatting "parts" ## and $##.## - you need to do the whole thing in the formula: =F28&" min. = "&TEXT(FIXED(D30/60,3)*F28,"$##.##") HTH "h." wrote: my cell is custom formatted to read, "## "min. =" $##.##" my formula is =FIXED(D30/60,3)*F28 the cell reads min. = $19.49 what i'm missing is the number of minutes, which is displayed in cell F28. so i just need to reference that cell at the start of my formula. the question is how?! thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
| Can I start a macro from a cell by using a formula | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
