Hi guys,
I have this formula and want to add a condition that if cell D5 is blank the formula should return a blank. At the moment it returns "FALSE" and I can't work out how to do it,
Can anyone help?
Thanks
I have this formula and want to add a condition that if cell D5 is blank the formula should return a blank. At the moment it returns "FALSE" and I can't work out how to do it,
Code:
=IF(D5="L",ROUND(ABS(IF(D5="L",(F5-1)*E5)-IF(G5<>"",(H5-1)*G5)-IF(I5<>"",(J5-1)*I5)-IF(K5<>"",(L5-1)*K5)-IF(M5<>"",(N5-1)*M5)-IF(O5<>"",(P5-1)*O5)),2),IF(D5="B",ROUND(ABS(IF(D5="B",(F5-1)*E5)-IF(G5<>"",(H5-1)*G5)-IF(I5<>"",(J5-1)*I5)-IF(K5<>"",(L5-1)*K5)-IF(M5<>"",(N5-1)*M5)-IF(O5<>"",(P5-1)*O5)),2)))
Can anyone help?
Thanks