View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mvnc mvnc is offline
external usenet poster
 
Posts: 1
Default how to create formula using excell

My problem :
I have to design sales model called Regular, X'tra, General, Farmer or
Multipurpose.
The target is Regular min 100new, X'tra min 30new, General min 84new, Farmer
between 250 - 300exist, then Multipurpose min 50new and max 125exist

In the colom AO is numeric of regular. Colom AP is numeric of X'Tra, Colom
BX is numerik of total of Regular New,X'tra New and Regular exist + X'tra
exist

Parameter to decide fill the colom AX for Sales Regular needed,AY for Sales
X'tra needed ,AZ for Sales General needed,BA for Farmer with 0 , 1 , or 2 as
Sales Model.

Appreciate of quick answer, thanks.

Maria