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
|