Guys,
I have 35 columns all with either "yes" or "no" drop down list options, if a "yes" is picked I want it to calculate a formula i.e. A1*B1 but if a "no" is selected I want it to move onto the next "Yes" which will have a different formula i.e. D1*E1, this is repeated 35 times any idea how I can get this into one formula?
Any ideas?
Bookmarks