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
Bookmarks