Hello I have a spread sheet which uses a macro to go from one sheet to another and copy and paste a price list in to the first.
The sheet has the IF function
=IF(H19="Yes",B19," ")
The problem comes when B19 is blank I want nothing to be displayed but it displays a 0. How can I get round this.
Bookmarks