Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Odd Numbers
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions |