Forum Discussion
Joe_Inspection
Jan 15, 2025Copper Contributor
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", "")))