Forum Discussion
#Value! when fields have no value
I have two spreadsheets with the same formula in one column ao each. The formula is =IF(BU6<1,"",IF(BU6>2,BU6+7)) I get #Value! for cells that have no value on one sheet but no on the other??? How...
Can you check if there is a space in cell BU6? In the attached example i entered a space in BU6 and the formula returns #VALUE!. As soon as i delete the space the formula works as intended.