Creating formulas for beginners

[Bagsy]

I recently posted a question on the Excel message board as to how to prevent some specific data being entered using “data validation”.
Somebody kindly gave me a formula to do what I required as shown.
=OR(ISERROR(SEARCH(" ",A1))=FALSE, A1*1=ROUND(A1*1,0))
Does anybody know of a good Excel 2000 book that can explain what a formula like this is doing (break it down step by step), so I can learn how to use them and write my own.
Any suggestions will be gratefully received

Bagsy

 

[sweater_vests_rock]

bagsy.

while i've not experienced any of these myself, i've heard all of them are good:

http://www.mrexcel.com/sunshop/index.php?action=category&id=bestsellers

enjoy! ben.

 

[Bagsy]

Thaqnks Ben

Bagsy