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.

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.

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.

Try this:

A1 = 1.15

A2: =ROUND(A1/2,2)

A3: =A1-A2

--
Biff
Microsoft Excel MVP


"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.

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.

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.