Get instant online 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
Need to solve a quaestion with IRR rate and cash flows.
Solved by F. H. in 24 mins
If I want to write a formula that states" "If this name shows up K24, and this word shows up in J24 pull this number from M24" I can creat that formula - however I need to drag this down so it pulls from row 24 - 60 - is there way to do this?
Solved by F. D. in 24 mins
I have a spread sheet that I need to reference cells on another sheet even when cells are shifted down on the target cells / sheet
Solved by A. W. in 12 mins
I am stuck trying to add +1 to the above cell. It works for the first then copy down. the cell formulars are the correct but does not add up stays on the second cell created.
Solved by I. D. in 12 mins
A friend of yours can invest in a project. The cost is $14,000. Annual cash flows are estimated to be $5,000 per year for six years, but could vary between $2,500 and $7,000. Your friend estimates that the cost of capital (interest rate) is 11%, but it could be as low as 9.5% and as high as 12%. The basis of the decision to invest will be whether the project has a positive net present value. Construct a tornado diagram for this problem. Based on the tornado diagram, advise your friend regarding whether to invest or not
Solved by D. S. in 22 mins
I need some help to apply filter to the tracker (spread sheet attached)
Solved by A. Q. in 19 mins
I am unable to sort some highlighted rows in a workbook.
Solved by C. E. in 21 mins
cell C1 contain the price of my product. cells C3 through C10 have quantities. When I do a formula for the first cell and copy the fomula it comes back like this
=sum(C3*C3) and then for the next cell =sum(C4*C4). These formulas should be =sum(C1*C3) and then =sum(C1*C4). How to correct. The first cell reference in the formula should always be C1 the second cell refence is always correct.
Solved by M. H. in 14 mins
i need a histogram to print all the relevant data from my worksheets after semi averaging and monthly comparison analysis are done
Solved by F. Y. in 22 mins
Using point and interval estimates to analyze the data address differences between regions’ mean scores. Present the results of your analysis in a set of four Excel charts showing the point estimates and confidence intervals
Solved by O. C. in 29 mins