Excel 2000 - Blank cell formula

[MJamison07]

I would like to do the following in Excel 2000:

I have created a form in Excel. If a cell is blank I want a message to appear in a different cell at the end of the form which reads - "Item not complete"

Thanks.

 

[SkipVought]

Hi,
are you talking about a UserForm or a spreadsheet that you are considering to be a form?

If the latter...

=IF(ISBLANK(A5),"Fill in, please","")
[/code
where A5 is the cell you want to test.

Hope this helps  :-) Skip,
metzgsk@voughtaircraft.com

 

[MJamison07]

Thanks for your tip but I was trying to test a range of cells for example:

In cell C15 I would want a formula that enters "incomplete item" if any of the following cells are blank - C2, C3, C6,C7,C11,C12

 

[SkipVought]

Try this...

=IF(OR(ISBLANK(C2),ISBLANK( C3),ISBLANK( C6),ISBLANK(C7),ISBLANK(C11),ISBLANK(C12)),"Msg","")

Skip,
metzgsk@voughtaircraft.com

 

[MJamison07]

That's it!! Thanks. I wasn't putting in the OR