Problem witn SUM

[wpettigrew]

I used teh following IF statement and now I cannot get the cell it is in to add up with other cells. How can I do this??


=IF(B91<=0,"10",IF(B91<=7,"6",IF(B91<=14,"4",IF(B91<=21,"2",IF(B91<=28,"0",IF(B91<=35,"-2",IF(B91>=42,"-4")))))))

[widemonk]

Its because of the quote marks. YOu have told it that if B91 is equal to or less than 0, to display a text string "10" rather than the number 10 and Excel cannot perform calculations on text.