I have seven columns in a spread sheet with values. I need to add a column and based on what is the total of those 7 columns do the following in the new column
if <20 enter a 1
if20-249 enter a 2
if 250 or up enter a 3
Can someone tell me how to do this. I have never used a formula. Thanks.