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

=IF(A2+A3<A1,A1,0)

Order quantity is 0 if A2:A3 A1

"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

One way:

=IF(A2+A3<=A1,A1,0)

I assume you do not need to order anything if the two quantities
exceed your minimum value.

Hope this helps.

Pete

On Jul 2, 8:40 pm, 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

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

I read it slightly differently to Toppers & Pete_UK.

Does:

=MAX(SUM(A2:A3),A1)

do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Debsdad" wrote in message
...
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

=(A2<A1)*(A3<A1)*A1


"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

Thanks all, Very simple problem just could'nt see the answer.

Debsdad

"Toppers" wrote:

=IF(A2+A3<A1,A1,0)

Order quantity is 0 if A2:A3 A1

"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