Get instant chat 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
I have a formula that works for my purposes, but i am wanting to know how do i manipulate it to do a function on a different sheet within a workbook
Solved by O. W. in 26 mins
I downloaded an excel file that already has x and y values and multiple data sheets. All of which had formulas that the person before me had added. everytime i try to graph these data points or take the averages from one of the pages all the numbers on everys single page changes
Solved by X. C. in 19 mins
If (C3-C5)> = C4, I2 should turn red or if A1 is smaller than the month in which we live I2 should turn red
If both conditions do not apply, the cell must remain uncoloured
Solved by A. L. in 20 mins
i want to get it soon as possible as forulae in excel to import from word
Solved by X. F. in 12 mins
I need help with Excel's Solver optimization tool with the spreadsheet attached.
Solved by Z. F. in 30 mins
Need help on how to subtract dates in excel. Whenever I subtract dates on a table the returning value is not the number of days. It returns numbers in date form. Ive tried using the DATEIF function as well and it still does not tell me the days.
Solved by X. E. in 27 mins
I am using 3 INDIRECT functions to find and gather rows of adjacent values from different worksheets inside STDEV.P. I would like to repeat this formula for several consecutive columns. The problem is that when 1 worksheet result returns N/A the whole formula returns N/A. If I use IFNA in front of each INDIRECT function, the formula results are still N/A. Any other suggestions?
Solved by A. L. in 11 mins
Is there a formula I can use to minus all of row 7 from all of row 12 or do I have to put individual formulas in each box?
If I have to do an individual formula in each box is there a way to make it "hidden" so I can just type a number in that box and it will minus it from the box above.
We current hand type (=54482.25-1429.45) to get our total and we were hoping for a way to make it less likely for there to be an error.
Solved by X. W. in 11 mins
I need a formula to help me find the top 5% of values in one column.
Solved by K. B. in 13 mins
INSTRUCTIONS:
Use an Excel formula to check if C2 cell is a 'FHA' Loan.
Then execute the following steps:
In cell E3 - If the 'Type of Loan' = FHA, multiply the value in C4 by 0.0175, if not return 0.
In cell E4 - If the 'Type of Loan' = FHA, multiply the value in C4 by 1.0175, if it is not an FHA Loan, then return the value in C4.
In cell E5 - If the 'Type of Loan' = FHA, multiply the value in C3 by .78, if not return 0.
Solved by Z. Q. in 22 mins