How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
53785
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

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: 4 years ago.
Category: General
Expert:  John D replied 4 years ago.

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

 

Customer: replied 4 years ago.
Only return a vale up to 99%, I need to also see 100%.
Expert:  John D replied 4 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...

 

 

John D and 52 other General Specialists are ready to help you
Customer: replied 4 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 4 years ago.

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

 

Thanks.

Expert:  John D replied 4 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%