not sure on how to do this, got 2 columns first has a dollar value, second
has the formula, the dollar value has both pos and neg value, based on what
value is in will return a word,
so +/- 1-500=tl +/-501-2000=ss and so on
I came up with this wich works for the pos but has to work for the neg as well
=if(and(a10,a1<501),"tl",if(and(a1500,a1<2000)," ss","")) and so on, is
there a way that the formula can be put in with out having to go something
like,
=if(and(a10,a1<5001,a1-501,a1<-0),tl,"") and so on
it's to look something like this
a1 $200 b1 tl
a2 $600 b2 ss
a3 -$300 b3 tl
a4 -$1000 b4 tl