Forum Discussion

Joe_Inspection's avatar
Joe_Inspection
Copper Contributor
Jan 15, 2025

Help with formula

New to Excel. Needing help on formula in picture. Everything works out until I enter a number inside C8 cell. When value is entered it returns a P back to G8. I need a 4 entered into G8 if there is a SC entered into D8

  • Does it help if you move the condition on D8 to the front?

    =IF(D8="SC", "4", IF(AND(C8<=0.221, C8>=0.001), "2", IF(AND(C8>=0.222, C8<=0.29), "P", "")))

Resources