ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to create formula using excell (https://www.excelbanter.com/new-users-excel/118823-how-create-formula-using-excell.html)

mvnc

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



ufo_pilot

how to create formula using excell
 
have you tried: place cursor in cell that you need formula for, select on the
" fx" icon.
from there choose what you need that works for you.

"mvnc" wrote:

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




All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com