Great thanks, that works

Duncan

"robert111" wrote:

>
> all if statements require 2 parts, the true and the false
>
> if(a1<10,a2,a3)
>
> so if a1 is 9 or less it returns a2, but if 10 or more it returns
> a3
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=554899
>
>