how to create formula using excell

M

mvnc

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
 
U

ufo_pilot

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top