Odd Numbers
your welcome
"BinaryOrc" wrote:
Thank you very much!
"Mike H" wrote:
Hi,
=CEILING(A1/2,0.01)
and
=FLOOR(A1/2,0.01)
Mike
"BinaryOrc" wrote:
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.
|