Originally Posted by
dojj
ok, i understand that
how do i apply it to a certain batch of cells then?
just put a1:a30 in and hope for the best right?
believe it or not i havent got excel on this laptop; otherwise i'd have given it a go for you
the help facility in excel is actually quite good, its how i learnt - give that a go. Type in "if statement" into the search top right of excel and it will give you examples
if you want to apply it to a range of cells then you simply say e.g. A2:A2000 (that means it will apply the formula to all data in cells A2 -> A2000
make sense?
Matt