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 is my guess:
=D8*
LOOKUP(H8,
{0;2.9;4.9},
D$2:D$4)
=D8*
LOOKUP(H8,
{0;2.9;4.9},
D$2:D$4)