Forum Discussion

lucinda1275's avatar
lucinda1275
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
Twifoo's avatar
Twifoo
Silver Contributor
Jan 08, 2020
My second guess is:
=IF(H2<5,
C3*D3,
C4*D4)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 08, 2020

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

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jan 08, 2020
    No need for a third guess. She guessed what I’m guessing.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 08, 2020

      Twifoo 

      When it's your turn to add =IF(C8="Old",... or like. 

Resources