View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bryan Bryan is offline
external usenet poster
 
Posts: 114
Default Custom Field label

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