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")))))))
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")))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks