B
BinaryOrc
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.
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.