Nesting IF function

[Excel Neophyte]

I am looking for a formula for Excel 2007. The formula I currently have is only partially working. Essentially I want the formula for cell Q6 to read: IF G10 is blank then add M6+G9, IF G9 is blank then add M6+G8, IF G8 is blank then add M6+G7, IF G7 is blank then add M6+G6.

=IF(G10="",M6+G9,IF(G9="",M6+G8,IF(G8="",M6+G7,IF(G7="",M6+G6,G10+M6))))

At this time if G10 is blank it works, however if G9, G8, or G7 is blank Q6 returns a #VALUE! because it is reading that part of the formula as the “if false” part.

I apologize that I haven’t added an example snapshot, but I haven’t had any luck being able to include one.

 

[Excel Neophyte]

Thanks TheCman81 this also works just like I wanted it to.