Text and Function Formulas
 

I am trying to create a function which in one cell will indicate the number
of overtime hours an employee worked in the pay period. I need the formulas
function to grab the number of overtime hours from another worksheet (in the
form of a number) as well as write the text "OT" right after the number. How
is this possible? I have had a few ideas but have not been able to make it
work yet...

Text and Function Formulas
 

use

=Sheet2!H10

or whatever cell it is, and then format the cell as 0"OT"

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"HRMSN" wrote in message
...
I am trying to create a function which in one cell will indicate the
number
of overtime hours an employee worked in the pay period. I need the
formulas
function to grab the number of overtime hours from another worksheet (in
the
form of a number) as well as write the text "OT" right after the number.
How
is this possible? I have had a few ideas but have not been able to make
it
work yet...

Text and Function Formulas
 

Assuming the overtime hours are in Sheet2, Cell A1, then in Sheet1, Cell A1
type =TEXT(Sheet2!A1,"0.0"& "OT"). The "0.0" is used for a single decimal
point. Change this as needed. The result is treated as text and cannot be
used directly for calculations.

If you do want cells that are equal "0" or are blank on Sheet2 to have a
value on Sheet1, use this formula: =IF(Sheet2!A1="",
"",IF(Sheet2!A1=0,"",(TEXT(Sheet2!A1,"0.0") &" OT")))

"HRMSN" wrote:

I am trying to create a function which in one cell will indicate the number
of overtime hours an employee worked in the pay period. I need the formulas
function to grab the number of overtime hours from another worksheet (in the
form of a number) as well as write the text "OT" right after the number. How
is this possible? I have had a few ideas but have not been able to make it
work yet...