?
Solved

Eliminate unwanted values

Posted on 2015-01-24
6
Medium Priority
?
124 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 2000 total points
ID: 40568511
=IF(COUNTA(H3)=0,"",(H3-G3)*100)

=IF(COUNTA(H3)=0,"",(H3-G3))
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: 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…

749 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