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?
No, I need to return if H is ❤️ =C2*D2, if H<5=C3*D3, if H = 5 or greater = C4*D4
Does this make sense?
A B C D
Old 33 1234 0.016923077
New 1 28 1950 0.014358974
New 2 31 860 0.015897436
New 3 33 435 0.016923077
My second guess is:
=IF(H2<5,
C3*D3,
C4*D4)
=IF(H2<5,
C3*D3,
C4*D4)
