team,
My formula works perfectly if I have some amount in the budgeted sale. As Soon as I put Zero in Sales the output is not what i expect it comes as 80+. i expect it to be Zero.
IF(AND(E5>-1,E5<0),"$0",IF(AND(E5>0,E5<18000),"$0 - $18k",IF(AND(E5>18000,E5<30000),"$18 - $30k",IF(AND(E5>30000,E5<40000),"$30 - $40k",IF(AND(E5>40000,E5<50000),"$40 - $50k",IF(AND(E5>50000,E5<60000),"$50 - $60k",IF(AND(E5>60000,E5<70000),"$60 - $70k","$80k +")))))))
Thanks team.
Melv
My formula works perfectly if I have some amount in the budgeted sale. As Soon as I put Zero in Sales the output is not what i expect it comes as 80+. i expect it to be Zero.
IF(AND(E5>-1,E5<0),"$0",IF(AND(E5>0,E5<18000),"$0 - $18k",IF(AND(E5>18000,E5<30000),"$18 - $30k",IF(AND(E5>30000,E5<40000),"$30 - $40k",IF(AND(E5>40000,E5<50000),"$40 - $50k",IF(AND(E5>50000,E5<60000),"$50 - $60k",IF(AND(E5>60000,E5<70000),"$60 - $70k","$80k +")))))))
Thanks team.
Melv