B
Bryan
How can I enter a formula in a cell, but but a custom text label be displayed
in the cell instead of the value of the formula?
Thanks
in the cell instead of the value of the formula?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
reno
Sounds like you need the IF Function such as
=if( formula, is true print this, is false print this or nothing)
something like this =if(A1>100, "Large","small")
=if( formula, is true print this, is false print this or nothing)
something like this =if(A1>100, "Large","small")
B
Bryan
Not quite.
Sorry I wasn't very clear.
I'm creating this spreadsheet for class, so I'm not completely familiar with
what I'm doing (data tables), but I'll try to explain it the best I can.
I'm trying to create a data table that references the formula in the cell.
(A two variable table.) So therefore, I need the formula in that cell,
however I want it to display text instead of the value of the function.
My instructions tell me to:
"Enter a formula for net monthly income value in cell D18. Replace the
default format for cell D18 with a custom label of 'customers'"
I hope this better explains what I'm trying to accomplish, and thank you for
your help, it's greatly appreciated.
Sorry I wasn't very clear.
I'm creating this spreadsheet for class, so I'm not completely familiar with
what I'm doing (data tables), but I'll try to explain it the best I can.
I'm trying to create a data table that references the formula in the cell.
(A two variable table.) So therefore, I need the formula in that cell,
however I want it to display text instead of the value of the function.
My instructions tell me to:
"Enter a formula for net monthly income value in cell D18. Replace the
default format for cell D18 with a custom label of 'customers'"
I hope this better explains what I'm trying to accomplish, and thank you for
your help, it's greatly appreciated.
R
reno
If you are trying to do calculation and then add text to the formula result,
such as format>cell>custom "Customer: " #,###
then when you do the caluculation say the result is 1947, what is displayed
in the cell is
Customer: 1,947
(but if you click on the cell you see the formula and you could continue to
manipulate it since the custom format doesn't effect anything except what is
displayed)
Hope this helps, but still a little unclear what monthly income has to do
w/customers, unless this is something like <$500, $501-600, $601-700 or
something like this.
Reno
such as format>cell>custom "Customer: " #,###
then when you do the caluculation say the result is 1947, what is displayed
in the cell is
Customer: 1,947
(but if you click on the cell you see the formula and you could continue to
manipulate it since the custom format doesn't effect anything except what is
displayed)
Hope this helps, but still a little unclear what monthly income has to do
w/customers, unless this is something like <$500, $501-600, $601-700 or
something like this.
Reno
B
Bryan
Its a scenario for a business adding a new service. The number of customers,
and the net monthly income of the company based on the number of customers.
But I think that is along the right lines, but I don't want to see anything
from the formula in that cell. (But on a side note, I would also be
interested in learning make the text display alongside the forumlua result.)
I'm playing with the customer cell formats (under the number column) but I
can't get it to accept text in the function at all, whether its in addition
to the formula or to replace it (unless i take out the "=" in which case it
is no longer a function). It just gives me an error telling me that there is
a problem with the formula.
The display should look something like this:
Massage Price
Customers $20 $21 $22 $23 $24
10
12 (Table values would
14 be monthly income
16 for the company)
I'm required to enter a formula in the cell that displays "customers" for
the table to reference to calculate the values at given prices.
And again, thank you for your help, I appreciate it greatly.
Bryan
and the net monthly income of the company based on the number of customers.
But I think that is along the right lines, but I don't want to see anything
from the formula in that cell. (But on a side note, I would also be
interested in learning make the text display alongside the forumlua result.)
I'm playing with the customer cell formats (under the number column) but I
can't get it to accept text in the function at all, whether its in addition
to the formula or to replace it (unless i take out the "=" in which case it
is no longer a function). It just gives me an error telling me that there is
a problem with the formula.
The display should look something like this:
Massage Price
Customers $20 $21 $22 $23 $24
10
12 (Table values would
14 be monthly income
16 for the company)
I'm required to enter a formula in the cell that displays "customers" for
the table to reference to calculate the values at given prices.
And again, thank you for your help, I appreciate it greatly.
Bryan
R
reno
Assuming Customers in A1 and values of ... in A2...n
The first case is $200 ($20 x 10 Customers) B2 by the formula (is the
revenue)what do you want to be displayed in B2, exactly...result of formula
or result of formula with some additional text? It seems your column heading
of Customers and your row headings of Amounts makes it pretty obvious waht
the results in the table mean.
The first case is $200 ($20 x 10 Customers) B2 by the formula (is the
revenue)what do you want to be displayed in B2, exactly...result of formula
or result of formula with some additional text? It seems your column heading
of Customers and your row headings of Amounts makes it pretty obvious waht
the results in the table mean.
B
Bryan
I want B2 to display net monthly income based on the number of customers and
the price. Thus I need the formula in A1 (which will calculate expenses) to
reference.
But I did eventually figure it out based on your last post.
I deleted out all the numerical formating under the custom setting, and
replaced it with the word "customer" only instead of leaving the "#,###" in
the format.
Thanks for your help
Bryan
the price. Thus I need the formula in A1 (which will calculate expenses) to
reference.
But I did eventually figure it out based on your last post.
I deleted out all the numerical formating under the custom setting, and
replaced it with the word "customer" only instead of leaving the "#,###" in
the format.
Thanks for your help
Bryan
R
reno
Bryan, I think you maybe talking about named ranges. In this case, you would
highlight A1 thru say A10 as the various numbers of customers and name the
range "customers" in the dialog box ust to the left of the function block,
and then do the same with the amounts, like b1thru b10, name like "amounts".
Then the formula in B1 thru B10 say would be [this would be copied over and
down as necessary]
customers*amounts,
this would always give you the correct amount of revenue, regardless of how
the worksheet might change, like adding columns. This makes is so that you
don't have to revise formulae all the time which tends to make for errors.
There is one other trick to check formulae en masse, this is Control-tilde,
hold down Control key and then touch the ~ key just to the left of 1 key,
this toggles between the cell results and the actual formula in the cell,
Cntl-~ returns the sheet to original view.
Hope this helps
highlight A1 thru say A10 as the various numbers of customers and name the
range "customers" in the dialog box ust to the left of the function block,
and then do the same with the amounts, like b1thru b10, name like "amounts".
Then the formula in B1 thru B10 say would be [this would be copied over and
down as necessary]
customers*amounts,
this would always give you the correct amount of revenue, regardless of how
the worksheet might change, like adding columns. This makes is so that you
don't have to revise formulae all the time which tends to make for errors.
There is one other trick to check formulae en masse, this is Control-tilde,
hold down Control key and then touch the ~ key just to the left of 1 key,
this toggles between the cell results and the actual formula in the cell,
Cntl-~ returns the sheet to original view.
Hope this helps
B
Bryan
No, I got everything working correctly.
I created a two-variable data table, and the cell A1 held the formula for
the table to reference, however, I changed the display format through custom
format like you told me, so it simply displays "customer" but the cell
actually holds a formula for net income. Then B1-B6 I had 6 different
prices. In A2-A13 I had different numbers of customers.
Outside the table I had revenue, expence, and net income calculations based
on other numers. I used the price as the row input, and the number of
customers as the customer input. The A1 cell which displays is now set to
simply display "customers", holds the reference to the cell which calculats
net monthly income.
So the table looks like what I posted above.
Customer (A1) 20 21 22 23 24 26
-----10----(Table values are the net monthly
-----20----income based on number of
-----30----customers and price.)
So everything is working now.
Thanks for your help, sorry for making things so complicated.
Bryan
I created a two-variable data table, and the cell A1 held the formula for
the table to reference, however, I changed the display format through custom
format like you told me, so it simply displays "customer" but the cell
actually holds a formula for net income. Then B1-B6 I had 6 different
prices. In A2-A13 I had different numbers of customers.
Outside the table I had revenue, expence, and net income calculations based
on other numers. I used the price as the row input, and the number of
customers as the customer input. The A1 cell which displays is now set to
simply display "customers", holds the reference to the cell which calculats
net monthly income.
So the table looks like what I posted above.
Customer (A1) 20 21 22 23 24 26
-----10----(Table values are the net monthly
-----20----income based on number of
-----30----customers and price.)
So everything is working now.
Thanks for your help, sorry for making things so complicated.
Bryan
reno said:Bryan, I think you maybe talking about named ranges. In this case, you would
highlight A1 thru say A10 as the various numbers of customers and name the
range "customers" in the dialog box ust to the left of the function block,
and then do the same with the amounts, like b1thru b10, name like "amounts".
Then the formula in B1 thru B10 say would be [this would be copied over and
down as necessary]
customers*amounts,
this would always give you the correct amount of revenue, regardless of how
the worksheet might change, like adding columns. This makes is so that you
don't have to revise formulae all the time which tends to make for errors.
There is one other trick to check formulae en masse, this is Control-tilde,
hold down Control key and then touch the ~ key just to the left of 1 key,
this toggles between the cell results and the actual formula in the cell,
Cntl-~ returns the sheet to original view.
Hope this helps
Bryan said:I want B2 to display net monthly income based on the number of customers and
the price. Thus I need the formula in A1 (which will calculate expenses) to
reference.
But I did eventually figure it out based on your last post.
I deleted out all the numerical formating under the custom setting, and
replaced it with the word "customer" only instead of leaving the "#,###" in
the format.
Thanks for your help
Bryan