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

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

I need the formula for time accrual to auto populate in E4 based on certain criteria. example: B4 = hire date E4= accrual rate If todays date is equal to or greater than 60 days but less than 1 year from B4 date then E4 = 1 If todays date is equal to or greater than 3 years but less than 4 years from B4 date then E4 = 1.08 If todays date is equal to or greater than 5 years but less than 9 years from B4 date then E4 = 1.5 If todays date is equal to or greater than 10 years but less than 14 years from B4 date then E4 = 1.58 If todays date is equal to or greater than 15 years from B4 date then E4 = 1.92

Solved by A. H. in 18 mins