Q: In excel i have the formula [=IF('Input Results'!O18=0,1,0)] is there a way that i can change this so that it is =IF('Input Results'!O18=0,1,0) Unless 'Input Results' has no data?
A: You probably want the ISBLANK function: =IF(ISBLANK('Input Results'!O18),"Your Message HERE",IF('Input Results'!O18=0,1,0)) or something like that