#VALUE error appears before data calculates

ProTee 

Dear Community,

First, I want to thank those who spent their time attempting to find a solution to my dilemma!

As a "Newbie", trying to teach myself Excel the past 5+ months and approaching 70, I finally get to be a contributor instead of a seeker!

After much trial and error, I've come up with the solution to get rid of the #VALUE! populating the cells.  Here is the simple solution below (It's usually simple, isn't it?  But the road there is very difficult.  How else do we learn?)

Original formula:    =IF(($G32-G10)>=35,+40,

                                   IF(($G$32-G10)>=25,+30,

                                   IF(($G$32-G10)>15,+20,

                                   IF(($G$32G10>=+10,

                                   IF(($G$32-G10)>-10,” “,

                                   IF(($G$32-G10)<=-35,-40,

                                   IF(($G$32-G10)<=-25,-30,

                                   IF(($G$32-G10)<=-15,-20,-10))))))))

IMPROVED formula:   

     1st line edit         =IFERROR(IF(($G32-G10)>=35,+40,

                    Added =IFERROR(

   Last line edit           IF(($G$32-G10)<=-15,-20,-10)))))))),"")

                                                                                Added ,"")

Once again, a GREAT BIG THANKS to all of you!