Need help with spreadsheet formula "#VALUE" error

[Ibonic]

Hi all, been working on this spreadsheet and have a "#VALUE" error I can't seem to eliminate, any help would be much appreciated, you can find the spreadsheet at the following link https://docs.google.com/file/d/0B50j4eNSlSxjemtqbWM5LVkzWG8/edit?usp=sharing This link is a public link viewable and downloadable to all. As you can see in the spreadsheet I have the Value error coming up in cells M14 through M19 and can't figure out how to eliminate the error but yet have the formulas work with the other cells. Thank you

 

[RonB1111]

Your formulas in J14 to J19 return "" when the IF conditions are all FALSE. Change the "" to 0 at the end of the J14:J19 formulas and you won't get the #VALUE error in M14:M19

 

[Ibonic]

Hi Ron, thanks for your help, much appreciated. Cheers