So I have these 2 defined formulas:
OnetoFive
=IF(adf!$Q$2:$Q$20000>90,"91-100",IF(adf!$Q$2:$Q$20000>80,"81-90",IF(adf!$Q$2:$Q$20000>70,"71-80",IF(adf!$Q$2:$Q$20000>60,"61-70",IF(adf!$Q$2:$Q$20000>50,"51-60",FALSE)))))
SixtoTen
=IF(adf!$Q$2:$Q$20000>40,"41-50",IF(adf!$Q$2:$Q$20000>30,"31-40",IF(adf!$Q$2:$Q$20000>70,"71-80",IF(adf!$Q$2:$Q$20000>20,"21-30",IF(adf!$Q$2:$Q$20000>10,"11-20",IF(adf!$Q$2:$Q$20000>0,"0-10","not Found"))))))
And I have a master formula =IF(SixToTen,SixToTen,OneToFive)
But it is returning #Value!
Any ideas on how to get this formula to work? I'm trying to create 10 conditions for bandwidth classification, where if a value 'X' is found, then return a label defining the data range in the cell with the formula (such as "71-80").
Thanks in advance!
OnetoFive
=IF(adf!$Q$2:$Q$20000>90,"91-100",IF(adf!$Q$2:$Q$20000>80,"81-90",IF(adf!$Q$2:$Q$20000>70,"71-80",IF(adf!$Q$2:$Q$20000>60,"61-70",IF(adf!$Q$2:$Q$20000>50,"51-60",FALSE)))))
SixtoTen
=IF(adf!$Q$2:$Q$20000>40,"41-50",IF(adf!$Q$2:$Q$20000>30,"31-40",IF(adf!$Q$2:$Q$20000>70,"71-80",IF(adf!$Q$2:$Q$20000>20,"21-30",IF(adf!$Q$2:$Q$20000>10,"11-20",IF(adf!$Q$2:$Q$20000>0,"0-10","not Found"))))))
And I have a master formula =IF(SixToTen,SixToTen,OneToFive)
But it is returning #Value!
Any ideas on how to get this formula to work? I'm trying to create 10 conditions for bandwidth classification, where if a value 'X' is found, then return a label defining the data range in the cell with the formula (such as "71-80").
Thanks in advance!