Solved

Correct percentage calculated

Posted on 2015-01-24
7
94 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
  • 5
  • 2
7 Comments
 

Author Comment

by:frugalmule
Comment Utility
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:
SimonAdept earned 500 total points
Comment Utility
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
Comment Utility
Outstanding.  Thank you!
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:frugalmule
Comment Utility
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:SimonAdept
Comment Utility
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
Comment Utility
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
Comment Utility
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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…
If your app took Google’s lash recently, here are the 5 most likely reasons.
This Micro Tutorial will demonstrate using Google Doc how to import live data to another spreadsheet in Google Spreadsheets using the IMPORTRANGE function.
This Micro Tutorial will demonstrate common damaging and frequent mistakes I see in most analytic audits. Most of them are campaign tagging mistakes, so this video will break it down into simple steps.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now