calculating a percentage based on a yes/no column

**hceoc_energy** · 03-07-2014, 07:16 PM

I have a spreadsheet that contains columns that if the person is cost-share, they have to pay 20% of the final cost: so I wanted to see if there was a formula that I could use that would calculate that. I will attach a blank example spreadsheet.

If it is Yes in cost share...i want it to calculate 20% of the cost...and if it is no..I want it to be blank or 0...is this possible? Please Help

Thank you!

example worksheet.xls

**Tony Valko** · 03-07-2014, 08:03 PM

Which column do you want the formula in?

I think this does what you want:

Entered in B2:

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

Format in your desired style.

Copy down as needed.

**hceoc_energy** · 03-07-2014, 08:24 PM

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!!!

**Tony Valko** · 03-07-2014, 08:33 PM

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.