Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Amature here!
Expense amount = 1,370.25 in A1 Client #1 owes 1/2 = $685.13 (A2) Client #2 owes 1/2 = $685.12 (A3) if I put the formula =A1/2 in A2, it returns $685.125, and then when I go to formatting it rounds to $685.13 (Correct) But then, using that same formula in A3, it gives me $685.13, when it should be $685.12. In A3, I tried using the formula =A1-A2, but it's still returning $685.13. Help please - thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I modify expense template to fit my needs? | New Users to Excel | |||
how to freez more five columns without splitting the panes? | Excel Worksheet Functions | |||
Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) | |||
Question for Bob Phillips re Splitting Names from Cells | Excel Discussion (Misc queries) | |||
How to change $ to £ in pre-formatted "Expense Statement" template | Excel Discussion (Misc queries) |