Forum Discussion
Help with an nested if statement
=IF(H8>2.9,$D$3*D8),IF(H8>4.9,$D$4*D8),IF(H8<3,$D$2*D8) it returns #VALUE1 What's wrong with my formula?
This works perfectly, thank you. I just need to add another condition if C8=Old =D1 please