T
Taylor
I'm having trouble creating a formula that performs the following function.
I want there to be a certain text output dependent upon which range bucket
the value in cell T87 falls into. Each bucket clause works when entered
individually, but when put together separated by commas, the output is
#VALUE. Is there a way to set up the formula so that only the TRUE response
is given and the FALSE responses are ignored? I've included the formula for
reference. Thanks for any help!
=IF(T87>=10000,"6% Net 90"),IF(AND(T87>=8000,T87<10000),"5% Net 90"),
IF(AND(T87>=5000,T87<8000),"4% Net 75"),IF(AND(T87>=3000,T87<5000),"3% Net
75"), IF(AND(T87>=2000,T87<3000),"2% Net 60"), IF(AND(T87>=1000,T87<2000),"1%
Net 60"),IF(T87<1000, "0% Net 30")
I want there to be a certain text output dependent upon which range bucket
the value in cell T87 falls into. Each bucket clause works when entered
individually, but when put together separated by commas, the output is
#VALUE. Is there a way to set up the formula so that only the TRUE response
is given and the FALSE responses are ignored? I've included the formula for
reference. Thanks for any help!
=IF(T87>=10000,"6% Net 90"),IF(AND(T87>=8000,T87<10000),"5% Net 90"),
IF(AND(T87>=5000,T87<8000),"4% Net 75"),IF(AND(T87>=3000,T87<5000),"3% Net
75"), IF(AND(T87>=2000,T87<3000),"2% Net 60"), IF(AND(T87>=1000,T87<2000),"1%
Net 60"),IF(T87<1000, "0% Net 30")