?
Solved

Correct percentage calculated

Posted on 2015-01-24
7
Medium Priority
?
98 Views
Last Modified: 2015-01-24
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
Comment
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
  • Learn & ask questions
  • 5
  • 2
7 Comments
 

Author Comment

by:frugalmule
ID: 40568625
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
 
LVL 18

Accepted Solution

by:
Simon earned 2000 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

by:frugalmule
ID: 40568636
Outstanding.  Thank you!
0
Industry Leaders: 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!

 

Author Comment

by:frugalmule
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

by:Simon
ID: 40568647
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
 

Author Comment

by:frugalmule
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

by:frugalmule
ID: 40568693
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question