Solved

Eliminate unwanted values

Posted on 2015-01-24
6
119 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
[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
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many of you may be aware of the recent Google Docs scam emails that have been floating around coming from various people that you know. Here's a guide on identifying How To Identify the Scam Email You will see an email from someone you’ve had co…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.

691 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