Solved

# If statement with a twist---URGENT

Posted on 2011-02-16

Hi All!

I have a large spreadsheet with nearly a million rows. I have a column (L)=Var% which is a percentage. What I need to do is create a column that tells the following:

if L >=0% but <=5% then '0'

if L >=10% but <=20% then '.15'

if L >=21% but <=40% then '.30'

if L >=41% but <=60% then '.50'

if L >=61% but <=80% then '.70'

if L <0% but >=-9% then '0'

if L <-10% but >=-20% then '-.15'

if L <-21% but >=-40% then '-.30'

if L <-41% but >=-60% then '-.50'

if L <-61% but >=-80% then '-.70'

if L <-81% but >=-99% then '-.80'

else '0'

Your help would be greatly appreciated.

spudmcc