Thread: [Solved] How to leave the next cell blank when a condition is met
View Single Post
 
Old 04-14-2017, 10:18 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If you don't like the conditional formatting approach you can try the following formula in cell I10:

=IF(($G10-DATEDIF($E10,EOMONTH(I$7,0),"d")<0)*(ISNUMBER(H10) ),"Delete Line",IF(($G10-DATEDIF($E10,EOMONTH(I$7,0),"d")<0)*(ISTEXT(H10)), "",($G10-DATEDIF($E10,EOMONTH(I$7,0),"d"))*$H10))

and copy as required.
Reply With Quote