Give these a try....

=ROUNDUP(A1/2,2)

=ROUNDDOWN(A1/2,2)

--
Rick (MVP - Excel)


"BinaryOrc" wrote in message
...
I am looking to determine if a dollar amount is odd. I need to split a
dollar
amount 50/50 onto two lines. For example, I have a dolar amount of $1.15.
My
two lines are calculated at $0.58 on each line. I realixe that Excel
calculates the value to $0.575 for each line, but my cells are formatted
at
standard dollars and cents.

I would like to do an if statement that would add half a cent to line 1
and
subtract half a cent from line 2 if the begiining dollar amount is an odd
amount.

So far I have been unsuccessful in doing this.

Any help would be greatly appreciated.