Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I need a formula to say the following: if > then 110 then *1.5 if less < 110 then 110
Solved by G. Q. in 20 mins
hello, i am a web developer with woocomerce. i am finishing off a large (ish) store and are looking to give him a launch present. I have an excell spreadsheet of the product data, 600 row, 60 columns. I want each cell to have a colour depending on the number held, use as an hex value, i dont mind really. If its text then a one colour, if an empty cell another. I am kind of looking like the DNA of the shop.
Solved by X. D. in 11 mins
Hi I want to format cells if they are lesser/lower than a specified date. It would be a great help if I get a solution as soon as possible
Solved by K. B. in 23 mins
I have a spreadsheet with a lot of columns and want a cell in each row that will have a comma-separated list of the columns that have data. Essentially, I think I need to create multiple "IF" functions within a cell that will output comma separated text based on whether a column is blank or not.
Solved by K. L. in 27 mins
If cell b2 = 56 c3 needs to return A* If cell b2 =50 c3 needs to return A and so on. How can I combine this into one formula
Solved by I. Y. in 22 mins
I need a formula where s36 = 1 if a10=s7 and c10=any value?
Solved by G. J. in 13 mins
I need a formula that sums two separate column and two separate cells and only shows an answer if the resulting number is between 0 and 365 ie L2-G2 but only show the answer if it is between 0 and 365. Thanks
Solved by V. E. in 40 mins
Would like to know how use the filter in excel with AND instead of OR So filtering three columns with a 0 and 1 and asking that all three show up if at least one has a number 1
Solved by B. E. in 20 mins
excel if x>=Y then display Y if x<= Y then display X or 0
Solved by K. U. in 18 mins
I want to check if the value in the excel activeCell is "Jan" and if this is so I want to check all the columns of the row
Solved by G. H. in 20 mins
1 2 60 61 62