Get instant live expert help on if 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
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
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
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
if cell a1 is greater than or less than 5% of b2 yes if not no
Solved by Z. D. in 14 mins
I need help with this formula: "Report" if "Revenue" divided by "Loads" is less than 55 and "OK" if greater than 55.
Solved by T. U. in 21 mins