Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 101
  • Last Modified:

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
0
frugalmule
Asked:
frugalmule
  • 5
  • 2
1 Solution
 
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
 
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:
Outstanding.  Thank you!
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now