how to create formula using excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top