User Profile
Josh_Osowiecki
Copper Contributor
Joined Apr 27, 2023
User Widgets
Recent Discussions
Re: How to calculate multiple due dates using Sumif and Workday functions
Yes! you are totally right! I hadn't noticed that I left the equal sign before the WORKDAY function, and forgot to close parenthesis after 10 and 14. I am still getting the hang of writing functions inside functions in Excel. Thank you again for your support!897Views0likes0CommentsRe: How to calculate multiple due dates using Sumif and Workday functions
Thanks for this! the only difference between our formulas is I closed the WORKDAY function in parenthesis (which should not matter. When I removed the parenthesis to match your function it worked! might be a weird bug? Do you get the same result? Either way, thank you for the reply! You just saved me a pretty major headache!969Views0likes2CommentsHow to calculate multiple due dates using Sumif and Workday functions
Hello, I am trying to calculate the due date for multiple projects based on an indicator. The deadlines are tracked by weekdays only. I attempted to achieve this by using the function below. Excel keeps kicking the function back with the generic 'There is a problem with this formula' dialogue box'. =IFS([@Indicator]=0,(=WORKDAY([@[Assigned Date]]),14),[@Indicator]=1,(=WORKDAY([@[Assigned Date]]),10)) My goal for the example above is to add '10' workdays to the assigned date if the indicator is '0' and if the indicator is '1' to add '14' workdays to the assigned date. Any guidance on this would be greatly appreciated!Solved1.1KViews0likes4CommentsRe: How to balance an expense sheet with different percentages
mathetes Thank you for sharing this! I guess the question I have boiled into one sentence is: Is there a function or formula that I can use to balance an expense sheet with repayments from 2 sources. I was not able to find an equation that did this in the shared spreadsheet. I currently use the following functions: Value 1: =SUMIFS(tblTransactions[Amount],tblTransactions[Person],'Data Validation'!E2,tblTransactions[Category Type],'Data Validation'!C2)*-1 [I use this function to sum the total expenses per person then multiply by -1 to return a positive value] then =SUMIF(tblTransactions[Category Type],"Expense",tblTransactions[Amount])*-1 [I use this function to sum the total expenses between both people in the table, then multiply by -1 to return a positive value] then Value 2: I multiply the the value returned above by .55 for person 1 and .45 for person 2 to return the value each person is responsible for] then Value 3: =SUMIFS(tblTransactions[Amount],tblTransactions[Person],'Data Validation'!E2,tblTransactions[Category Type],'Data Validation'!C10) [I do this to sum the total payments made by person 1 to the other to balance the expense sheet] then I subtract Value 1-Value 2-Value 3 This only works if person 1 pays person 2. When person 2 pays person one the logic fails. Any guidance would be greatly appreciated!851Views0likes2CommentsRe: How to balance an expense sheet with different percentages
mathetesThank you for the time and energy req for your thoughtful reply! I look forward to reviewing your ex to learn how you went about it. However, I am unable to view the sheet shared through the link. Do you mind changing the sharing permissions or the equations you used? Thank you, Josh977Views0likes4CommentsHow to balance an expense sheet with different percentages
Hello! I am trying to keep a balanced expense sheet for my household where one person is responsible for 55% of expenses and the other responsible for 45% of expenses. I also want to have the ability to build repayments to rebalance in the same table. -- I am having difficulty figuring out how to balance the spreadsheet when I add in repayments. This is supposed to track who owes who how much. This generally works but the equation in the 'Owed' table on the 'Analysis' sheet only works in person 2 owes person 1 money. When person 1 owes person 2 money the equation breaks. I know Sumif functions are generally avoidable with pivot tables but, I am having difficulty figuring out how to make them work with my data. I have attached a copy of the sheet with some data to demonstrate the issue. I have also commented describing the purpose of every table and column in the sheet. Any guidance would be greatly appreciated!1.3KViews0likes6CommentsWrong Value Returned When Using A Calculated Time
Hello All! I am attempting to create a simple timesheet that will automate processes to save some time. I am running into an issue when I multiply my rate column by my hour column. To calculate total hours I am using the below equation: =IF([@[End Time]]>[@[Start Time]],[@[End Time]]-[@[Start Time]],1-[@[Start Time]]+[@[End Time]]) This provides a value for a time range in an integer from 0-1. I adjusted to format to h:mm to show the total hours. For example, a record with a Start time of 7 am and an End time of 5 pm will display as '10.00' in a separate field labeled 'Total Hours'. The rate being used in this example is $20/hour I am running into an issue when I multiply the rate field by the corresponding total hours field. For the example above excel is returning $8.33 instead of $200. I know this is because Excel is giving me the solution to 0.416(of a day)*$20. I would like to know how to make Excel instead provide the solution to 10 hours*$20. Any help would be greatly appreciated!Solved1.8KViews0likes2Comments
Recent Blog Articles
No content to show