Hi, I have attached an excel doc.
Would be grateful with a little help with 2 formulas.
In the table under the Points+/- header (column F) and Profit +/- (column H)
how do I get the cells to only show data when the Closing Price (column J) has been filled?
To recap, I would like the cells to remain blank when the Status (column E) says Closed and only have columns F & J populate
when column J is filled.
Help would be very much appreciated, thanks.
Bookmarks