Recent Feedback
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.
Hello again
Here is your formula
=IF(AND(B2>0,C2>0,D2>0),C2/B2,"")
Let me know if you have any questions
Thanks
Only return a vale up to 99%, I need to also see 100%.
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...
Experience: Math, science and 25 years experience in computer programming
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%.
I found the problem and was able to correct the formula.
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%