“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

What is the formula for greater than or less than on excel?

Solved by T. F. 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 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