Get instant live Excel expert help with IF Functions
“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 want info to appear in a cell if another cell reaches a particular threshold, but I keep getting a formula parse error. Here is my formula: =IF ('Start Here'!B8,>= 1 , [Pallet 1] , [ ])
Solved by D. H. in 17 mins
Hello, the SUM is not working in the Sort by Valor in Pivot Table. Sort by COUNT() excel works but, if you look at the attachment you will see that sum is a fake. I have checked everything and I really don't understand why is making like this
Solved by X. A. in 13 mins
I'm stuck on #2, regarding the nested if functions that I need.
Solved by T. U. in 12 mins
I am trying to crease a complex if statement using IF AND and OR
Solved by K. E. in 19 mins
If date = March 31, 2016 then person is "In" if Value 1 is <=15 or Value 2 is >=0.05
If date = April 1, 2016 then the person is "In" if Value 1 is <=15 or Value 2 is >=0.10
Solved by S. W. in 27 mins
Buy if the stock price is greater than 10 and forward PE ratio is less than 15
Buy if Mkt Cap is better than 50.00 and return on assets is better than 6.00
Hold otherwise
Solved by C. C. in 14 mins
I am trying to see if the items in column A are also included in column B.
Solved by A. U. in 12 mins
I need help with a formula. What I want to do is if Cell E12 is a Y for yes, then cell H4 would equal the date of cell H4 plus 32 days.
Solved by A. W. in 28 mins
want something that will choose one amount if age is 49 and another amount if age 50
Solved by T. S. in 24 mins
I want to include a rank function in an if function but when there is no value to be ranked, I do not want to display a rank.
Solved by V. L. in 21 mins