LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MLK MLK is offline
external usenet poster
 
Posts: 81
Default Help please... Simple calculation - with unexpected results

I am getting unexpected results from a simple multiplication formula. Column
A contains rates, Column B contains billing discounts and Col C calculates
the billing $.

For example: Col A = 100, Col B = .44 and Column C calculation is: a2*(
50*37.5*0.85)*b2
Both Column B and C display only 2 decimals.

The answer that comes out is $70,492.79 but I'm expecting $70,125. It
appears to be calculating at 7 decimal places but should only be calculating
at 2. When I enter the actuals numbers into a function (100*1593.75*.44)
the answers comes out right (70,125).

Am I missing something basic? I have done a ton of formulas but have not
come across this before.
 
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
A simple date calculation question. Seldum Excel Discussion (Misc queries) 2 June 26th 06 04:56 PM
The ispmt function is providing unexpected results Louis Zaffino Excel Worksheet Functions 1 May 3rd 06 03:56 AM
Mortgage calculation after a large extra payment Gary Wachs Excel Discussion (Misc queries) 6 April 16th 06 08:55 AM
Mortgage calculation after a large extra payment Gary Wachs Excel Worksheet Functions 4 April 16th 06 02:01 AM
need explanation on simple time calculation Georgina Excel Discussion (Misc queries) 1 April 2nd 06 02:36 PM


All times are GMT +1. The time now is 06:03 AM.

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"