Range
 

I have this formula:

-- If IsEmpty(Range(€œd9€�) Then
Range (€œe11").Formula = €œ=(e5:e8)/4€�
End If

I want to insert the Else statement to do this:

If d8 and d9 are both empty then (e5:e7)/3

How do I do it?
Thanks,
Howard


Howard

Range
 

If IsEmpty(Range("D8:D9")) Then
Range("E11").Formula = "=(E5:E7)/3"
ElseIf IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

Charles Chickering
Howard wrote:
I have this formula:

-- If IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

I want to insert the Else statement to do this:

If d8 and d9 are both empty then (e5:e7)/3

How do I do it?
Thanks,
Howard


Howard

Range
 

isempty() won't work like you want with multiple cells.

Either

if isempty(range("D8").value) _
and isempty(range("d9").value) then
'both empty

or

if application.counta(range("d8:d9")) = 0 then
'both empty



Die_Another_Day wrote:

If IsEmpty(Range("D8:D9")) Then
Range("E11").Formula = "=(E5:E7)/3"
ElseIf IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

Charles Chickering
Howard wrote:
I have this formula:

-- If IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

I want to insert the Else statement to do this:

If d8 and d9 are both empty then (e5:e7)/3

How do I do it?
Thanks,
Howard


Howard

--

Dave Peterson

Range
 

Thanks, Dave.

That will do it!
--
Howard


"Dave Peterson" wrote:

isempty() won't work like you want with multiple cells.

Either

if isempty(range("D8").value) _
and isempty(range("d9").value) then
'both empty

or

if application.counta(range("d8:d9")) = 0 then
'both empty



Die_Another_Day wrote:

If IsEmpty(Range("D8:D9")) Then
Range("E11").Formula = "=(E5:E7)/3"
ElseIf IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

Charles Chickering
Howard wrote:
I have this formula:

-- If IsEmpty(Range("d9") Then
Range ("e11").Formula = "=(e5:e8)/4"
End If

I want to insert the Else statement to do this:

If d8 and d9 are both empty then (e5:e7)/3

How do I do it?
Thanks,
Howard


Howard

--

Dave Peterson