Get instant free 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
I have 2 cells, P71 and Q71. They both could be 0. As I am trying to resolve a scoring of an array of P68 to Q71, when both of the cells are 0 I need to show that the scoring if either 0 or a value that the difference of the cells. Thought I had but keep getting an error.
Solved by M. H. in 25 mins
I need a formula that will take a length and width of a product and times it by 2 (to make a door) and then divide it to show how many 6 meter lengths of that product are required to make the door. I have it that it works up until 9 quantity but after that it doesn't calculate correctly. I must mention the length and with relate back to another cell where you can change the length and width to what size of door you are making and the length comes from another tab within the excel workbook. ie for 1 door you require 3 lengths so for 10 doors you would require 30 lengths but it calculates at 28 lengths
Solved by T. S. in 19 mins
I want to modify my formula in such a way that it will be applied only for the cells containing number
Solved by V. L. in 21 mins
I want to Have a formula thats add cells together once i enter the word yes into that cell
Solved by I. J. in 18 mins
Hi
I need to activate excel file from Macro file cell reference value. B2 is formula based cell and file name created as cell reference b2. B2 cell reference file already opened but i need to activate that file.
Below is the code here. i am not able to open this file.
Sub Work()
Dim wbook As String
Dim filename As String
filename = Range("B2")
wbook = filename
workbooks(filename).Activate
End Sub
please help us me to open this file.
Solved by V. Q. in 30 mins
HI, I AM TRYING TO FIGURE OUT A FORMULA FOR CALCULATING WHEN MY CELL D9 IS OVER THE TIME OF 4:30PM. TO BE LOCATED IN CELL E9
Solved by D. A. in 13 mins
I'm not sure how to write a formula correctly
Solved by C. F. in 21 mins
Hi, I wish to create a chart which row a, column a is say a value of 5, row b column a is a value of 5, but row c column a is a value of 6 (incrementing every 2 cells)
Solved by E. L. in 30 mins
I’m trying to find formulas that calculate the values for slope, intercept, and r^2 for a log regression (the values from the log regression formula in the chart view).
Solved by K. D. in 27 mins
Hi
I want to Fetch live data from a cryptocurrency market website to google sheet and Compare it with the other cryptocurrency market website and It should show the percent change between the two realtime in terms of numbers and graphs
Solved by V. E. in 20 mins