How to leave the next cell blank when a condition is met

		Microsoft Office Forums > Microsoft Excel > Excel
How to leave the next cell blank when a condition is met

FAQ

Thread Tools

Display Modes

04-14-2017, 10:18 AM

xor

Windows 10 How to leave the next cell blank when a condition is met

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation - Prevent blank cell based on a condition	dawd	Excel	2	08-12-2015 05:44 AM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Place 0 in blank cell	mbesspiata	Excel	5	06-20-2014 07:00 PM
Copying data from one cell to another where condition is third cell	fairyca	Excel	4	03-30-2014 08:22 AM
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.