Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 142
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
How do I create an If/or formula with more then two answers? LisaLisaKK Excel Discussion (Misc queries) 4 October 5th 06 06:39 PM
How do I create a 26 'tier' IF formula? callum Excel Discussion (Misc queries) 5 October 23rd 05 04:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"