Getting a cell to "appear" blank if there is no info in it

Hi!! Can someone help me with my Gross Margin sheet? I want all items in column J to "appear" blank unless someone has put a number in column I. If I enter anything in the costs column (Column G) it returns that same cost in column J or it appears as $0.00. (see picture and attached file).

I only want J to show the Gross margin dollar amount if someone has put a number in column I. Otherwise, I want it to "appear" blank.

margin sheet pic.jpg

Another way is to use custom formatting to show zero values as blanks. Select the cells from J2 to J100 then right click and click on Format Cells | Number | Custom and you should see this format string in the box:

"$"#,##0.00

All you need to do is to add two semicolons to the end of this string:

"$"#,##0.00;;

then click OK.

That will show negative values as blanks also, so if you don't want this then you can do:

"$"#,##0.00;"-$"#,##0.00;

Hope this helps.

Pete

Originally Posted by Pete_UK

Another way is to use custom formatting to show zero values as blanks. Select the cells from J2 to J100 then right click and click on Format Cells | Number | Custom and you should see this format string in the box:

"$"#,##0.00

All you need to do is to add two semicolons to the end of this string:

"$"#,##0.00;;

then click OK.

That will show negative values as blanks also, so if you don't want this then you can do:

"$"#,##0.00;"-$"#,##0.00;

Hope this helps.

Pete

This worked great!! Thank you!!!

That's good to hear.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete