Get instant live expert help on I need help with excel greater than and 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
What is the formula for greater than or less than on excel?
Solved by T. F. in 21 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
% distribution of values that are greater than 10000 and less than 10000
Solved by O. J. in 30 mins
I need a formula that will return a figure of-7 if greater then 31 but less than 91 and give a figure of -14 if greater than 90 but less than 182
Solved by S. A. in 16 mins
6. On the Sales Sheet (It is blank). Create a lookup table. In the first column there should be the values to setup the different categories based on Total Sales. Anything less than $3000 is considered Low Sales. Anything greater than $3000 but less than $7000 is considered OK Sales. Anything greater than $7000 but less than $11000 is considered Average Sales. Anything greater than $11000 but less than $15000 is considered Above Average Sales. Anything Greater than $15000 is considered Excellent Sales.
Solved by A. S. in 26 mins