Else Without IF Error Message

**Chris424** · 12-09-2008, 04:12 AM

Hello All,

Im getting "Else Without IF" Error Message and cant for the life of me work out why.

Please Login or Register  to view this content.

D21 is a merged cell (would this make any difference?)
Does anyone know why I am getting this?

**sweep** · 12-09-2008, 04:24 AM

Hi,

you have a mixture of a "line" IF and a block IF

Try,

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

**davesexcel** · 12-09-2008, 04:30 AM

Even a shorter version

Please Login or Register  to view this content.

**Chris424** · 12-09-2008, 04:32 AM

You are genius'!

Thankyou!