Sandy

The base amount is for me to keep track of changes. In the base amount
column I input the adjusted amount year to year. So next year the base
amount becomes what the adjusted amount was this year, and so forth and so
on. I inputed the formula that you and Bob gave me and it seemed to work
until I plugged in enough changes to the "base amount" that I ended up with a
case where it was

E9 = 183.99 ("Base Amount")
G9 = 189.51 (Adjusted Amount)
I9 = 189.00 (Rounded Amount)

Is it a matter of just carrying out more decimal places? What I am seeing
is that the G9 field is being rounded up to 189.51 (acutal is 189.5097).
Would that affect the results of I9 at all?

Thanks

"Sandy Mann" wrote:

I don't understand where the Base amount comes in but to round G9 to the
value in I9 try:

=IF(MOD(G9,1)0.5,ROUNDUP(G9,0),ROUNDDOWN(G9,0))

or

=ROUND(G9-10^-10,0.5)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"UBR362" wrote in message
...
Dave

Here is what I want

E9 = 150.00 (Base amount)
G9 = 154.50 (Adjusted amount)
I9 = 154.00 (Trying to get this to round down to 154 not 155)

I plugged in what you gave me but it didn't work. Heres what I tried.

=IF(G9=.51,ROUNDUP(G9,0),ROUNDDOWN(G9,0))

This gave me 155 which I need it to round down to 154.

Thanks


"Dave F" wrote:

Look at the ROUNDDOWN and ROUNDUP features

=IF(A1=.51,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

Dave

--
Brevity is the soul of wit.


"UBR362" wrote:

Want to know if this is even possible. I need excel to round numbers
down
that are .50 and lower and up for numbers that are .51 and higher.
Excel
tends to round up when numbers are .50 and higher.
So for instance
10.51 and higher would need to round up to 11 whereas
10.50 and lower would round down 10.
I am very unfamiliar with formulas so if you can explain to me what to
do
step by step I would appreciate it.

Thanks