skeeeter56
New Member
- Joined
- Nov 26, 2016
- Messages
- 42
- Office Version
- 2019
- Platform
- Windows
Cell N13 that contains this formula
=IF(ISBLANK(R6),"",IF(ROUND(O13-K13,2)=0,4,N6/O13))
Cell Q6 contains =SUM(E6:J6) and remains empty till a value is input into Cells E6:J6
I want N13 to remain blank till a value is shown in R6 and then to complete the rest of formula.
I hope this is possible.
=IF(ISBLANK(R6),"",IF(ROUND(O13-K13,2)=0,4,N6/O13))
Cell Q6 contains =SUM(E6:J6) and remains empty till a value is input into Cells E6:J6
I want N13 to remain blank till a value is shown in R6 and then to complete the rest of formula.
I hope this is possible.