Hey folks,
I am kind of a newb to Excel. I have come up with this formula that works (I was really supprised when I hit enter and it actually worked) but I was wondering if theres any way to simplify it..

=
IF(AND(E3<>"",E4="",E5="",E6="",E7="",E8="",E9="",E10="",E11="",E12="",E13="",E14="",E15="",E16="",E17="",E18="",E19="",E20="",E21="",E22="",E23="",E24="",E25="",E26="",E27=""),D3,"NOTHING FOLLOWS")
Basically it checks E3 to make sure something is there AND that E4 through E27 are blank... if those two conditions are met then D3 becomes the output... otherwise and error (nothing follows) is given.

Is there som way to shorten this for the blank cells? something like ..

=IF(AND(E3<>"",E4:E27=""),D3,"NOTHING FOLLOWS")
I have tried doing that but it just says NAME? in the cell when I hit enter... is this the right format or is there an easier way to do what I want?

Thanks,
-LF