User Profile
Josh_Osowiecki
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
How 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!Solved918Views0likes4CommentsHow 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!933Views0likes6CommentsWrong 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.5KViews0likes2Comments
Groups
Recent Blog Articles
No content to show