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!

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
if K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)
Solved by E. S. in 19 mins
i have 3 columns, need to put result in 4th column of column 1 if data then column 2 if data then column 3 if data. only one result posted
Solved by G. E. in 20 mins
I want to set the background color for my cells but don't know the right formula, for example If "processed" (color=green) or if "declined" (color =red)
Solved by V. J. in 25 mins
I have a value in cel A2 say 10,000 , & in cell B2 to F2 i have months & some values getting a total of 13000 (B2 to F2). I need a forrmula to know the difference between A2 & (B2 to F2) should not go less than zero.. B2 is 2000 ; C2 is 4000 ; D2 is 2000 ; E2 is 4000 ; F2 is 1000 (13000 in total). If i see the difference its -3000. But i want a formula that stops by not goin to negative (columns getting added from back) in sense if i look to the last 3 columns its 7000 & last 4 columns is 11000 (whixh is higher that A2) ... so i need the diff of 3000 as out put (A2 - sum(D2:F2) is it possible
Solved by C. C. in 34 mins
if cells a1:a10 in sheet1 = cell a1 in sheet 2. Then how do I sum(b1:10) (but only the cells where a1:a10 in sheet1 = a1 in sheet 2) in sheet 1, to b1 in sheet 2
Solved by G. Y. in 40 mins
Using the Logical IF function, compute the tax on income with more than two (2) tax brackets.
Solved by F. Y. in 20 mins
Can someone review my my formula logic in the yellow cells? It's pretty self explanatory, just IF and COUNT functions sorting data. Let me know if you have any questions!
Solved by E. L. in 30 mins
1 2 111 112 113 128 129

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc