Forum Discussion

frankb485's avatar
frankb485
Copper Contributor
Mar 31, 2022

Multiple IF Statements

I am trying to create a spreadsheet for a customer for irrigation pricing.  I have a dropdown menu created that will highlight the current rate they have selected.

I'm trying to create an annual savings column that will pull the value from the selected rate and apply it to that particular rate but when I write my IF statement it tells me I have too many values.

=IF($B6="DAILY CONTROL",,IF($B6="AG ADVANTAGE",H21-H13,IF($B6="TWO-DAY CONTROL",H29-H13,IF($B6="ONE-DAY CONTROL",H37-H13,IF($B6="NO CONTROL",H45-H13,,)))))

 

Formulas and Functions

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 31, 2022

    frankb485 

    From syntax point of view this one works

    =IF(  $B6 = "DAILY CONTROL", "have no idea what",
  IF( $B6="AG ADVANTAGE",    H21-H13,
  IF( $B6="TWO-DAY CONTROL", H29-H13,
  IF( $B6="ONE-DAY CONTROL", H37-H13,
  IF( $B6="NO CONTROL",      H45-H13,
      "more unknown")
))))

Resources