Need formula

D

Debsdad

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
 
P

Pete_UK

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
 
D

driller

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

regards,
driller
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top