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