Solved

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

Posted on 2011-02-16
2
267 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 250 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 250 total points
ID: 34908000
Here is one approach:

=IF(B4="","", your formula)
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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

862 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