LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Splitting an expense

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I modify expense template to fit my needs? Cal Thompson New Users to Excel 2 July 21st 06 07:41 PM
how to freez more five columns without splitting the panes? TatYnkA Excel Worksheet Functions 1 April 12th 06 04:54 PM
Template to track credit card expenses and expense reports combi sunshinelover Excel Discussion (Misc queries) 2 August 18th 05 02:58 AM
Question for Bob Phillips re Splitting Names from Cells Paul Sheppard Excel Discussion (Misc queries) 8 August 3rd 05 09:00 AM
How to change $ to £ in pre-formatted "Expense Statement" template Ardnanrigh Excel Discussion (Misc queries) 6 February 4th 05 10:09 PM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"