Help with an nested if statement

Question

=IF(H8&gt;2.9,$D$3*D8),IF(H8&gt;4.9,$D$4*D8),IF(H8&lt;3,$D$2*D8)&nbsp;it returns #VALUE1&nbsp;What's wrong with my formula?

sergeibaklan · Answer

Twifoo&nbsp;, need third guess when&nbsp;=C2*D2 shall be returned

sergeibaklan · Answer

lucinda1275&nbsp;
Perhaps you mean
=D8*IF(H8&gt;2.9,$D$3,IF(H8&gt;4.9,$D$4,$D$2))

lucinda1275 · Answer

SergeiBaklan&nbsp;No, I need to return if H is ❤️ =C2*D2, if H&lt;5=C3*D3, if H = 5 or greater = C4*D4&nbsp;Does this make sense?&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DOld&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.016923077New 1&nbsp;&nbsp;&nbsp;&nbsp; 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1950&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.014358974New 2&nbsp;&nbsp;&nbsp;&nbsp; 31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 860&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.015897436New 3&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 435&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.016923077

sergeibaklan · Answer

lucinda1275&nbsp;
That's fully different from what was in first post.
&nbsp;
Anyway, and what is the first condition here
...return if H is&nbsp;❤️=C2*D2, if H&lt;5...

twifoo · Answer

This is my guess:=D8*LOOKUP(H8,{0;2.9;4.9},D$2:D$4)

Forum Discussion

Help with an nested if statement

9 Replies

Resources