Debbie<
You example is not necessarily round UP; 27.997 rounds to 28
A normal rounding of 27.3 would be 27 while a round UP would be 28

I will assume you do want to round up and I will use the ROUNDUP function.
If you want just simple rounding, change it to ROUND

Suppose A1 holds the current salary and you want a 12.5% increase rounded up
to the nearest dollar:
In B1 use this formula =ROUNDUP(A1*1.125,0) or if you prefer
=ROUNDUP(A1+A1*12.5%,0)
The zero here tells Excel to roundup to an integer (no decimals / no cents
in this case)

If A2 has the next person's salary just copy the formula down the column by
dragging or double clicking B1's fill handle (small solid square in the
lower right corner when the cell is selected)
If your data goes across the worksheet you can bout the formula in the cell
below and drag across the row.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Leprechan" wrote in message
...
I have prepared salary scales using simple formulas where the calculations
are based on a % increase. I would like the answers to be rounded up eg:
$27.997 to be $28.00. I am unclear on how to apply the roundup function
( I
believe that is the one I s/b using..) Do I use roundup in the initial
formula & then copy across the page? Can someone pls provide me with an
example.

Thanks
Debbie