Correct percentage calculated

Assistance is greatly appreciated.  I need to correct the following formula.


Correct K5 formula =IF(COUNTA(H5)=0,ʺʺ,(H5-G5))
to answer this question...       What percentage over the value in G5 is the value in H5?

https://docs.google.com/spreadsheets/d/10hHAoSGpQd5nOu2YXY89_cY3Mjbw89z0qk6EFVYJuZY/edit?usp=drive_web#gid=0
frugalmuleAsked:
Who is Participating?
 
SimonCommented:
Operating on the same principle (empty if the sold price is not present)

Assuming you want a consistent formula for the whole column
=IF(COUNTA(H2)>0,(H2-G2)/G2,"")
and fill down

If just for row 5
=IF(COUNTA(H5)>0,(H5-G5)/G5,"")
0
 
frugalmuleAuthor Commented:
For reference, the related question removed the value if nothing yet existed in the Sold column.
http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_28603236.html
0
 
frugalmuleAuthor Commented:
Outstanding.  Thank you!
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
frugalmuleAuthor Commented:
Now I need a way to script the automatic hiding of columns B, J, M, O, and P for any user that is not an administrator such that they cannot be seen at all.

Do you have any suggestions on where I should post that?

It will require google scripting, I think.
0
 
SimonCommented:
Sounds like a new question:
To help you formulate it well:
How do you determine which users are administrators?  - is it from AD user accounts or a separate system?
0
 
frugalmuleAuthor Commented:
Google administrators.  The users of this sheet that are logged-in as administrators.  Once we get it formulated correctly, I'll post it so that adequate credit is given.  Thank you for the help.
0
 
frugalmuleAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.