Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Are the parentheses the problem?
The formula is to show t's Share of the profit.
=SUM(U14)-((SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320)))+(Phases!L29)*0.55+('Profit & Loss'!U15)))))) Payments by customer: $2587.11 Total cost of the project: - $1178.68 __________ Total Profit: $1408.43 "t"'s Share (55%) of the profit: x.55= $ 774.77 Plus the amounts paid by "t" $ 928.43 _________ "t"'s total sha $1703.20 =SUM(U14 is $2587.11 =SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320 is $ 422.11 =SUMIF('Cost Plus Invoice'!O8:O1510,"m,'Cost Plus Invoice'!T8:T1320 is $ 150.00 =SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320 is $ 100.00 =SUMIF('Cost Entry'!O8:O1510,"t",'Cost Entry'!T8:T1320 is $ 377.36 =SUMIF('Cost Entry'!O8:O1510,"m",'Cost Entry'!T8:T1320 is $ 000.00 =SUMIF('Cost Entry'!O8:O1510,"r",'Cost Entry'!T8:T1320 is $ 000.00 +(Phases!L29 is $128.96 [payroll] +('Profit & Loss'!U15 is $928.43 [paid by "t" Why is this formula not working even when excel corrects it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are the parentheses the problem?
On Sun, 14 Jul 2013 00:55:00 +0100, Mark74w1 wrote:
Why is this formula not working even when excel corrects it? What do you mean by "not working"? Returns an error? If so, what is the error? Causes Excel to crash? Returns an incorrect result? If so, what is the original data and what is the returned result? (This might be more easily transferred by posting a workbook on some accessible site (e.g. Skydrive) and posting a link here. |
#3
|
|||
|
|||
Quote:
The total done on a calculator is the correct results as I showed in the math example, but the results shown in the target cell is a different total. If I move the parentheses to change the way it groups the answer is still wrong. I'm new to Skydrive and would be glad to get the workbook to you if I new how.. Thanks, Mark |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are the parentheses the problem?
On Mon, 15 Jul 2013 23:15:52 +0100, Mark74w1 wrote:
'Ron Rosenfeld[_2_ Wrote: ;1612717']On Sun, 14 Jul 2013 00:55:00 +0100, Mark74w1 wrote: - Why is this formula not working even when excel corrects it?- What do you mean by "not working"? Returns an error? If so, what is the error? Causes Excel to crash? Returns an incorrect result? If so, what is the original data and what is the returned result? (This might be more easily transferred by posting a workbook on some accessible site (e.g. Skydrive) and posting a link here. Thank you for responding Ron. The total done on a calculator is the correct results as I showed in the math example, but the results shown in the target cell is a different total. If I move the parentheses to change the way it groups the answer is still wrong. I'm new to Skydrive and would be glad to get the workbook to you if I new how.. Thanks, Mark For SkyDrive, see instructions he http://windows.microsoft.com/en-us/s...rive-help=tab1 You do need a Microsoft or Hotmail account to use it. There are other sharing sites, also. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are the parentheses the problem?
"Mark74w1" wrote:
Subject: Are the parentheses the problem? Yes, that is the problem, for the most part. Try the following: =(U14 -(SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320) +SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320) +SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320) +SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320) +SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320) +SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320) +Phases!L29))*0.55+'Profit & Loss'!U15 Even simpler: =(U14 -SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320) -SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320) -SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320) -Phases!L29)*0.55+'Profit & Loss'!U15 However, multiplying dollar-and-cents by 0.55 is risky: often, the result is not exact to the penny. For example, 1.23*0.55 is 0.6765. If you display with only 2 decimal places, it will __look__ like 0.68. But it is still __really__ 0.6765. That might adversely affect dependent calculation elsewhere. So the best formula is: =ROUND((U14 -SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320) -SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320) -SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320) -SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320) -Phases!L29)*0.55+'Profit & Loss'!U15, 2) Caveat: That assumes that each of those cells are constants or their formulas have been rounded to 2 decimal places. ----- original message ----- "Mark74w1" wrote: The formula is to show t's Share of the profit. =SUM(U14)-((SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"m",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Plus Invoice'!O8:O1510,"r",'Cost Plus Invoice'!T8:T1320))+((SUMIF('Cost Entry'!O7:O1320,"t",'Cost Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"m",'Cost Entry'!T7:T1320))+((SUMIF('Cost Entry'!O7:O1320,"r",'Cost Entry'!T7:T1320)))+(Phases!L29)*0.55+('Profit & Loss'!U15)))))) Payments by customer: $2587.11 Total cost of the project: - $1178.68 __________ Total Profit: $1408.43 "t"'s Share (55%) of the profit: x.55= $ 774.77 Plus the amounts paid by "t" $ 928.43 _________ "t"'s total sha $1703.20 =SUM(U14 is $2587.11 =SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320 is $ 422.11 =SUMIF('Cost Plus Invoice'!O8:O1510,"m,'Cost Plus Invoice'!T8:T1320 is $ 150.00 =SUMIF('Cost Plus Invoice'!O8:O1510,"t",'Cost Plus Invoice'!T8:T1320 is $ 100.00 =SUMIF('Cost Entry'!O8:O1510,"t",'Cost Entry'!T8:T1320 is $ 377.36 =SUMIF('Cost Entry'!O8:O1510,"m",'Cost Entry'!T8:T1320 is $ 000.00 =SUMIF('Cost Entry'!O8:O1510,"r",'Cost Entry'!T8:T1320 is $ 000.00 +(Phases!L29 is $128.96 [payroll] +('Profit & Loss'!U15 is $928.43 [paid by "t" Why is this formula not working even when excel corrects it? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are the parentheses the problem?
"Mark74w1" wrote:
I'm new to Skydrive and would be glad to get the workbook to you if I new how. skydrive.live.com is the worst file-sharing website, IMHO. Its only benefit for users of other Microsoft websites (e.g. hotmail.com) is: they can use the same login for Skydrive. Some other file-sharing websites a Box.Net: http://www.box.net/files MediaFi http://www.mediafire.com FileFactory: http://www.filefactory.com FileSavr: http://www.filesavr.com RapidSha http://www.rapidshare.com I use box.net. It is easy to set up a free login. After you upload the file (straight-forward), click on Share, copy the URL ("link to this file"), and paste it into a posting here. Caveat: box.net has made a change recently that I do not like: we can no longer disable preview when someone tries to download the file. Preview does not work in some cases because it does not support some Excel features. Just ignore any preview errors and download the file. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are the parentheses the problem?
On Mon, 15 Jul 2013 20:17:35 -0700, "joeu2004" wrote:
"Mark74w1" wrote: I'm new to Skydrive and would be glad to get the workbook to you if I new how. skydrive.live.com is the worst file-sharing website, IMHO. Its only benefit for users of other Microsoft websites (e.g. hotmail.com) is: they can use the same login for Skydrive. Some other file-sharing websites a Since I have a MS account, for accessing their various groups, that's not a problem (I never use hotmail). Two other uses that are good for me is that the contents can be synchronized across various computers/devices; and it appears as a folder in Windows Explorer, enabling easy transfer of files to/from. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Put parentheses around figures | Excel Programming | |||
parentheses around a capital C | Excel Discussion (Misc queries) | |||
number in parentheses | Excel Discussion (Misc queries) | |||
parentheses | Excel Worksheet Functions | |||
Removing parentheses | Excel Worksheet Functions |