Solved

Eliminate unwanted values

Posted on 2015-01-24
6
112 Views
Last Modified: 2015-01-24
Eliminate unwanted values.

If H3 is empty then do not display anything in J3 or K3

https://docs.google.com/spreadsheets/d/10hHAoSGpQd5nOu2YXY89_cY3Mjbw89z0qk6EFVYJuZY/edit?usp=drive_web#gid=0

Assistance is greatly appreciated.
0
Comment
Question by:frugalmule
  • 3
  • 3
6 Comments
 
LVL 1

Expert Comment

by:Geekamo
ID: 40568476
Formula for J3 =

=IF(H3="",(H3-G3)*100,"")

Formula for K3 =

=IF(H3="",(H3-G3),"")

Does that help you at all?
0
 

Author Comment

by:frugalmule
ID: 40568489
No, J3 and K3 still show values.
0
 
LVL 1

Accepted Solution

by:
Geekamo earned 500 total points
ID: 40568511
=IF(COUNTA(H3)=0,"",(H3-G3)*100)

=IF(COUNTA(H3)=0,"",(H3-G3))
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:frugalmule
ID: 40568589
Close but I noticed this issue with the percentage.Capture.PNG
0
 
LVL 1

Expert Comment

by:Geekamo
ID: 40568704
I'm not sure I understand?
0
 

Author Comment

by:frugalmule
ID: 40568723
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
Google is more than just a search engine. Over the years the company has developed a wide range of online services that are readily available to all users. This article highlights how one can use Google services for simple project management.
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contri…
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…

911 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

22 Experts available now in Live!

Get 1:1 Help Now