Sep 30 2020 05:36 AM
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
Sep 30 2020 05:46 AM - edited Sep 30 2020 05:52 AM
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