Mar 31 2022 12:59 PM
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,,)))))
Mar 31 2022 01:23 PM
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")
))))
Mar 31 2022 01:42 PM