=IF(A1<"","100","")

Believe starguy meant:
=IF(A1<"",100,"")

Drop the quotes for numbers, otherwise it'll be returned as text numbers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---