Example below. I would like the current column to reflect blank rather than zero. It is making it so the formulas in the "needed" "cost" and "$ worth in stock" columns are giving me what is seen below instead of remaining blank until a value is entered into the "current" row. Thanks!
PRICE PER LOT l IDEAL IN STOCK l MIN IN STOCK l CURRENT l NEEDED l COST l $ WORTH IN STOCK
$16.97 l 10 l 6 l l 10 l $169.70 l FALSE
Last edited by Jennifer Storkson; 12-16-2013 at 07:12 PM. Reason: numbers not lining up how they were supposed to.
That did not post the way I was hoping. But hopefully someone will know what I'm talking about!!!
Hi and welcome to the forum
It's hard to make out what you have there, but if you want to show nothing until something is entered into another cell, try something like this...
=if(a1="","",A1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for the welcome! What I am trying to do is have the blank cell reflect no value until something is entered in said blank cell. The other cells currently have formulas that are based on the blank cell and are showing values if it is left blank.
Then you need to apply my suggestion to those other formulas then
o.K., I am not the most experienced at excel. In one cell I have a basic =a1-a2 formula. Can you tell me how I would write it to combine the formula you have and the existing one?
for something like that, it would look like this...
=if(a1="","",a1-a2)
or depending on which cell would be empty...
=if(a2="","",a1-a2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks