Forum Discussion
Disregard cells appearing as blank, but still containing formulas
Hi, I've put together the following formula. =IF(OR($E51="",$F51=""),"",IF(OR($I$4="4 Week",$I$4="Please Select"),$F51-$E51+1,IF(AND(OR($I$4="13 Week",$I$4="26 Week"),AND($E51>=$D$6,$F51<=$E$44)),$...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.