Solved

# Correct percentage calculated

Posted on 2015-01-24
97 Views
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?

0
Question by:frugalmule
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5
• 2

Author Comment

ID: 40568625
For reference, the related question removed the value if nothing yet existed in the Sold column.
0

LVL 18

Accepted Solution

Simon earned 500 total points
ID: 40568630
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

Author Closing Comment

ID: 40568636
Outstanding.  Thank you!
0

Author Comment

ID: 40568643
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

LVL 18

Expert Comment

ID: 40568647
Sounds like a new question:
How do you determine which users are administrators?  - is it from AD user accounts or a separate system?
0

Author Comment

ID: 40568651
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

Author Comment

ID: 40568693
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the encryption capabilities built into Google Apps and how these features can help you meet privacy policy and regulatory compliance, but are not a full solution. Understand and compare the most popular email encryption services for Google A…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates in Google Analytics how to create a custom report that shows you traffic over time using the month of year dimensions. There are also instructions on how to fix Google's odd month of year formatting, which Microsoft …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month3 days, 4 hours left to enroll