I am attempting to calculate earnings based on multiple work based scenarios. I have created drop down validations across multiple columns. Each drop down affects a per unit wage. Most units are based on pages typed while others are based on hours spent on the job. Therefore I need to calculate total revenue based on a formula that can dynamically do math on the various drop down choices and apply each choice's rate of charge to apply to a grand total.

The jobs are currently tracked on a single row with many columns. I need the ability to add as many rows as needed with the formulas/code working as jobs are added. If anyone is willing to help I will gladly share the base file for examination. The following is a loose example.

Cell B3 contains page count I input. Simple numeric. I typed 300 pages. My initial logic was to set up a base cell (lets say B20) to hold a base calculation based on pages multiplied by a rate of $3.75 a page [=sum(b3*3.75)] This is base pay. If I choose a true statement from any of the drop downs (yes/no) I need to manipulate the base number and either add a conditional amount or leave the base calculation alone.

If I choose Yes in B5 that would indicate an additional 50 cents a page. If I choose Yes in B6 that's $1.50 per page added. If I change a response to No the additional fee is removed. I cant store the values for per page rate in the cell being validated to my knowledge. That would be cool if someone knows how. This is a Boolean thing for sure. Just not sure how to tell Excel how to organize it. (If this and that but not this do that) kind of stuff..

Any help is greatly appreciated.