Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

I have a small formula in the B colounm and the C colounm

Posted on 2011-02-16
2
Medium Priority
?
274 Views
Last Modified: 2012-05-11
I have a small formula in the B colounm and the C colounm I dont want the value to show up
until I put a number in B4 then C4 will show the value. the c4 should remain blank untill i put a number in c4 excel
0
Comment
Question by:1030071002
2 Comments
 
LVL 4

Assisted Solution

by:ChuckDeezel
ChuckDeezel earned 1000 total points
ID: 34907988
Check out this forum post. It has several methods of suppressing the formulas until data is entered:

http://www.ozgrid.com/forum/showthread.php?t=21428&page=1

Alternately check this out too:

http://excel.bigresource.com/Suppress-DIV-0-in-formula-Z7D1SEdb.html
0
 
LVL 24

Accepted Solution

by:
StephenJR earned 1000 total points
ID: 34908000
Here is one approach:

=IF(B4="","", your formula)
0

Featured Post

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!

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

886 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