how can i stop my worksheet from formula calculation until all the cells for the formula are filled
D danny boahn Dec 19, 2006 #1 how can i stop my worksheet from formula calculation until all the cells for the formula are filled
N Nick Hodge Dec 19, 2006 #2 Danny Wrap it in an IF statement =IF(A1="","",A1/B1) or similar -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
Danny Wrap it in an IF statement =IF(A1="","",A1/B1) or similar -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
N Nick Hodge Dec 19, 2006 #3 Danny How about =IF(OR(B10="",B9="",H5="",E10=""),"",(B10-B9)/(H5-E10)) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
Danny How about =IF(OR(B10="",B9="",H5="",E10=""),"",(B10-B9)/(H5-E10)) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
