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

Trying to take the total sum of cells B3 through B6 and if the value is greater than or equal to 2400, put YES or an icon symbol, but if it's less than 2400 put NO, or an opposite icon symbol. This is what I was entering: =IFSUM("B3:B6">=2400,"YES","NO")

Solved by V. Y. in 27 mins

Hi, I need a formula that can do the following -If E11 is greater than or equal to O1 but less than or equal to O2 then generate 1.923 in I11 -If E11 is greater than or equal to O3 but less than or equal to O4 then generate 2.885 in I11 -If E11 is greater than or equal to O5 then generate 3.846 in I11 I have to do this for every cell in column E

Solved by E. L. in 11 mins

I want cell I23 to say pass in green if the value in cell F23 is greater than or equal to the value in G23 or less than or equal to the value inH23. I want cell I23 to sat Fail in Red if the value in cell F23 is greater than or equal to the value in G23 or less than or equal to the value inH23

Solved by O. D. in 17 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

Need formulas: If column BB is NOT greater than or equal to three times AY = False If column BB IS greater than or equal to three times AY = True

Solved by I. E. in 27 mins