Are you stuck on Excel or Google Sheets?

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

excel if x>=Y then display Y if x<= Y then display X or 0

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

if K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)

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

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)

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

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

Using the Logical IF function, compute the tax on income with more than two (2) tax brackets.

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!