• 100% Satisfaction Guarantee
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
53785
John D is online now

# On an Excel spreadsheet I need a formula to calculate the following: If

### Customer Question

On an Excel spreadsheet I need a formula to calculate the following:
If cell B2 cantains a number of persons to be trained,
cell C2 contains a number of persons trained to date,
cell D2 contains a number of those remaining to be trained,

I need E2 to return a vale of percentage of those trained so far.

When there is no value in B, C, or D 2 I need the cell E2 to remain blank.
Submitted: 5 years ago.
Category: General
Expert:  John D replied 5 years ago.

Hello again

=IF(AND(B2>0,C2>0,D2>0),C2/B2,"")

Let me know if you have any questions

Thanks

Customer: replied 5 years ago.
Only return a vale up to 99%, I need to also see 100%.
Expert:  John D replied 5 years ago.

I am not sure what that means, especially if I do not know what values you have in the B, and C cells.

I will be happy to look further into this but I think I have answered your original question. In the meantime thanks in advance...

Customer: replied 5 years ago.
I do not believe the answer is complete, the formula is returning the correct value up to 99% but will not display when you reach 100%.
Customer: replied 5 years ago.

I found the problem and was able to correct the formula.

Thanks.

Expert:  John D replied 5 years ago.

Thanks

The problem is you asked that all three cells should have values, and if cell D2 has a value then B and C cannot be 100%