Get instant live expert help on count if less than
“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
Need a formula that will delete a cell in D column if the character count is less than or more than 10 characters long.
Solved by D. C. in 28 mins
I am trying to count numbers in a column if they are less than or equal to a value in C20. It works when I do "=" but not when I combine with less than. What am I doing wrong?
=COUNTIF($H$26:$H$67,"<="&C20)
Solved by V. D. in 23 mins
I'm trying to get a count of the difference where the difference is greater than and less than in column E. I tried an if, then using greater than 0 but it's not working properly for me.
Solved by T. D. in 27 mins
if i have criteria that needs to be met to create a specific color
if e2 is less than or equal to 70, green or if e2 is less than or equal to 90, blue or if e2 is greater than 90 but f2 is is less than equal to 110, blue, or if e2 is greater than 90 but f2 is is less than equal to 115, yellow, or if e2 is greater than 90 but f2 is is less than equal to 120, pink, or if e2 is greater than 90 and if f2 is greater than 120, red
Solved by K. H. in 24 mins
If a calculated cell is less than 0 = 0, if the same cell is greater that 0 that multiplied by 12
a1:a4 if greater than zero a5 x 12 if a5 is less than 0 = 0
Solved by G. H. in 21 mins