Get instant live expert help with Excel and Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
it will have the annual totals on the first page. On the following pages it will be arranged by month. But titles on tops. Income All of these totals will accumulate and total on the first page from the pages behind... Jan, Feb, Mar, Apr, May, June... Dec
Solved by V. H. in 26 mins
On Tab "Employee Information" I need Column U to use an if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG for the Employee's Taxable Gross Wage, and using this number find the Gross Taxable Percentage from the named group "SingleFedTaxTable" (or tab "Data" range H14 through I20), to find where the The Taxable Gross Wage falls between the H and I columns on the Data tab, the percentage on J14 the J20 from the row which the The Taxable Gross Wage falls in between then needs to be displayed on the "Employee Information" in column U.
If the answer is "M" I need for it to do the same as above, but using the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32.
If the answer is "DNW" I just need it to answer with a 0.
If there any way this can be worked out?
Solved by D. Y. in 21 mins
I have a template of scorecard, then I want to add bonus remark if the average score was 90% & above remarks should be $500 & , then if 80%-89% remarks should be $400 & if 70%-79% remarks must be $300 and failed remarks if the average was 70% below
Solved by A. A. in 27 mins
I need a data set to move to another tab in the workbook as it passes a specific date.
Solved by V. F. in 16 mins
Having an issue with a tool that I built that autopopulates cells based on dropdown choices
Solved by T. H. in 20 mins
So I have sheet named "Master Suburban Tenant List 1.1" and it has a bunch of companies in them that are either clients or pursuits. I added columns in column "N" that is for clients and column "O" for pursuits. I want to write a macro so when I put a "Y" in that column it will automatically copy the whole row and paste it into the sheets labeled "Pursuing" or "Clients". Is their anyway to send back the written code for this?
Solved by I. J. in 27 mins
I want to add one more month of income to the total of the prior 11 months for a projection of total income for year. What is the formula?
Solved by A. J. in 19 mins
Hi,
Need help with a SUMIF formula, I cann
Solved by Z. A. in 23 mins
Is there a formula to calculate the number of weeks between a hire date and a termination date?
Solved by A. D. in 26 mins
If any of the cells in the file are empty then the whole row should be highlighted in Red color
Solved by T. S. in 19 mins