not quite clear for me..how about if a1=a2=a3, (no blanks?)
what result u need to obtain...something like what?

regards,
driller
--
*****
birds of the same feather flock together..



"Debsdad" wrote:

Hi all,
I need to create a formula in excel to do the following:
In Cell A1 I have a Min number, Cells A2:A3 gives me qty's in other areas,
If A2:A3 is les than A1 the i need to order Qty in A1. What will the formula
be to disply this?

Thanks all,
Debsdad