LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Bill Kuunders
 
Posts: n/a
Default

Thank you for the feedback.
It made my day.
Bill K
"gracious" wrote in
message ...

Gracious...
Your percentages do not add up to 100
You need to divide each individual job cost into the sum of the
job costs not into the invoice total.i.e. 171.61 into 280.83 to get
61.1085%
etc.
--
Greetings from New Zealand
Bill K


Thank you so very much! I guess I had looked at it too long and got
frustrated and didn't realize that I was adding in the H/C to
calculate the %....whew...what a relief thank you for setting me
straight and all the way from New Zealand!!! :) TY Bill K HUGS HUGS
HUGS ;)


--
gracious
------------------------------------------------------------------------
gracious's Profile:
http://www.excelforum.com/member.php...o&userid=23166
View this thread: http://www.excelforum.com/showthread...hreadid=382922





 
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
Help with function to add percentage to cell based on checkbox. foxgguy2005 Excel Worksheet Functions 3 June 1st 05 05:52 AM
Add to my Function / formula Roelamp Excel Worksheet Functions 0 May 1st 05 10:54 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
percentage formula Tracy Excel Discussion (Misc queries) 1 April 5th 05 12:40 AM
Function within a TEXT FORMULA SteveFil Excel Worksheet Functions 2 January 4th 05 04:33 PM


All times are GMT +1. The time now is 04:45 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"