Forum Discussion

Copper Contributor

Jan 08, 2020

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?

Formulas and Functions

Diamond Contributor

Jan 08, 2020

Perhaps you mean

=D8*IF(H8>2.9,$D$3,IF(H8>4.9,$D$4,$D$2))

lucinda1275
Copper Contributor
Jan 08, 2020
SergeiBaklan
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
- Twifoo
  Silver Contributor
  Jan 08, 2020
  My second guess is:
  =IF(H2<5,
  C3*D3,
  C4*D4)
  - SergeiBaklan
    Diamond Contributor
    Jan 08, 2020
    Twifoo , need third guess when =C2*D2 shall be returned
- SergeiBaklan
  Diamond Contributor
  Jan 08, 2020
  lucinda1275
  
  That's fully different from what was in first post.
  
  Anyway, and what is the first condition here
  
  ...return if H is ❤️=C2*D2, if H<5...

Resources