software

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 quot;OTquot; right after the number. How
is this possible? I have had a few ideas but have not been able to make it
work yet...

use

=Sheet2!H10

or whatever cell it is, and then format the cell as 0quot;OTquot;

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;HRMSNquot; gt; wrote in message
...
gt; I am trying to create a function which in one cell will indicate the
number
gt; of overtime hours an employee worked in the pay period. I need the
formulas
gt; function to grab the number of overtime hours from another worksheet (in
the
gt; form of a number) as well as write the text quot;OTquot; right after the number.
How
gt; is this possible? I have had a few ideas but have not been able to make
it
gt; work yet...
Assuming the overtime hours are in Sheet2, Cell A1, then in Sheet1, Cell A1
type =TEXT(Sheet2!A1,quot;0.0quot;amp; quot;OTquot;). The quot;0.0quot; 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 quot;0quot; or are blank on Sheet2 to have a
value on Sheet1, use this formula: =IF(Sheet2!A1=quot;quot;,
quot;quot;,IF(Sheet2!A1=0,quot;quot;,(TEXT(Sheet2!A1,quot;0.0quot;) amp;quot; OTquot;)))

quot;HRMSNquot; wrote:

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