I am using the following formula in Column Y, Row 6: =IF(O3>0,W3/2,W3). Before I enter anything into the preceding cells that Y:6 will calculate on, Y:6 automatically shows #N/A. Is there a way I can have Y:6 stay blank until I enter numbers in the cells that it will be calculating on. Hope this makes sense and Thanks in advance for your help.