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

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(A1100, "Large","small")

"Bryan" wrote:

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

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.

"reno" wrote:

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(A1100, "Large","small")

"Bryan" wrote:

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

If you are trying to do calculation and then add text to the formula result,
such as formatcellcustom "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

"Bryan" wrote:

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.

"reno" wrote:

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(A1100, "Large","small")

"Bryan" wrote:

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

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

"reno" wrote:

If you are trying to do calculation and then add text to the formula result,
such as formatcellcustom "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

"Bryan" wrote:

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.

"reno" wrote:

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(A1100, "Large","small")

"Bryan" wrote:

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

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.

"reno" wrote:

If you are trying to do calculation and then add text to the formula result,
such as formatcellcustom "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

"Bryan" wrote:

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.

"reno" wrote:

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(A1100, "Large","small")

"Bryan" wrote:

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

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



"reno" wrote:

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.

"reno" wrote:

If you are trying to do calculation and then add text to the formula result,
such as formatcellcustom "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

"Bryan" wrote:

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.

"reno" wrote:

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(A1100, "Large","small")

"Bryan" wrote:

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