What is the if function to only have the formula work if there is something in the cell. tia
P Phil Mar 27, 2007 #1 What is the if function to only have the formula work if there is something in the cell. tia
M Mike Mar 28, 2007 #4 this should help explain if =IF(A1<>"","This is True because there is a value in cell A1","This is False because there is no value in cell A1")
this should help explain if =IF(A1<>"","This is True because there is a value in cell A1","This is False because there is no value in cell A1")