Forum Discussion
Cell references
In a column, I am referencing cells on another sheet of the same book. If there is no data in the cells that are being referenced, I get a 0 returned. How can I make this blank? i.e. =Details!C11 ...
In Sheet2, enter this formula =IF('Details'!C11:C20="","")
You can copy down the formula using fill handle
For the IF False, you can put in whatever result you wanna see if the logical test is false