calculating a percentage based on a yes/no column

example worksheet.xls

Thank you!

It worked... I just changed the formula to fit the columns that I needed!
If i used the example spreadsheet it worked.. I also was able to use it on the worksheet I needed it for by just changing the cells

=IF(A2="Yes",E2*0.2,"")

and it did it for me... I had a lot of columns Thank you!!!

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.