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

Trusted by people who work at