Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: how to keep recored of how many items sold

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    uk LONDON
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    in this shop every phone should be conunted ie it should have how many fonez in stock n
    i am trin to make a stock recorder for a shop selling mobile phone n i don't no how to make a message pop up if the stock of a phone(8310) goes under 5 n it should say 'reorder nk 8310'
    And if n e fone is not sold for whole month or loong time than it should pup up sayin 'out on offer'
    OR ANY ALTERNATIVE WAYS ROUND THIS WILL BE APPRECIATED.
    thank u

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 13:09, rajface2face wrote:
    in this shop every phone should be conunted ie it should have how many fonez in stock n
    i am trin to make a stock recorder for a shop selling mobile phone n i don't no how to make a message pop up if the stock of a phone(8310) goes under 5 n it should say 'reorder nk 8310'
    And if n e fone is not sold for whole month or loong time than it should pup up sayin 'out on offer'
    OR ANY ALTERNATIVE WAYS ROUND THIS WILL BE APPRECIATED.
    thank u
    if cell A1 contains the number of phones in stock and you want the message to appear in cell B1 then use the formula

    =IF(A1<5,"Reorder Nokia 8310","")


    Regards,

    Gary Hewitt-Long

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    uk LONDON
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thankx but i wanted to know hw do i record the number of items sold ie it should have number in stock n when each one item iz sold t should be recorded in n i wated to no how would this work. do u get wat i mean i mean the system it self should detect how many fonez sold n how many left not me entring the number sold
    for example the store has 6 nk 8310 mobiles n if one is sold than it should be detected that a item iz sold n needs to be reordere in other words it iz a AUTOMATED STOCK CHECKER. and i think just one formula would not be enough for this i think a couple of formulaes wll be required.
    THANK U hope 2 here soon from u.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 14:39, rajface2face wrote:
    thankx but i wanted to know hw do i record the number of items sold ie it should have number in stock n when each one item iz sold t should be recorded in n i wated to no how would this work. do u get wat i mean i mean the system it self should detect how many fonez sold n how many left not me entring the number sold
    for example the store has 6 nk 8310 mobiles n if one is sold than it should be detected that a item iz sold n needs to be reordere in other words it iz a AUTOMATED STOCK CHECKER. and i think just one formula would not be enough for this i think a couple of formulaes wll be required.
    THANK U hope 2 here soon from u.
    for a system to automatically detect that the phone is sold excel would somehow need to be linked in with your till?

    However you decide to do it, somehow something needs to trigger that there has been a sale and which stock item needs to have its stock count amended.

    How would excel knw that a phone has been sold?



    Regards,

    Gary Hewitt-Long

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    uk LONDON
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 15:50, gplhl wrote:
    On 2002-02-26 14:39, rajface2face wrote:
    thankx but i wanted to know hw do i record the number of items sold ie it should have number in stock n when each one item iz sold t should be recorded in n i wated to no how would this work. do u get wat i mean i mean the system it self should detect how many fonez sold n how many left not me entring the number sold
    for example the store has 6 nk 8310 mobiles n if one is sold than it should be detected that a item iz sold n needs to be reordere in other words it iz a AUTOMATED STOCK CHECKER. and i think just one formula would not be enough for this i think a couple of formulaes wll be required.
    THANK U hope 2 here soon from u.
    for a system to automatically detect that the phone is sold excel would somehow need to be linked in with your till?

    However you decide to do it, somehow something needs to trigger that there has been a sale and which stock item needs to have its stock count amended.

    How would excel knw that a phone has been sold?

    Exactly thats wat i mean. i t will be like a deals over phone like pp call in n order mobie phones. n when a phone has been sold than wat kind of macro or formula should i use to tell the systemm tat so n so item is sold i mean the system i am making is for the mnagr of the company n this system sholud have SUMIN so it can be told that this many of so n so item sold n the system is updated every week ie the maneger is told at end of the week that this many 8310s were sold n he keys tha in to keep a rec ord n i need help in every thing in this system i have writen. the whole program if u can give me n e ideas for this SPREADSHEET project 4 A level . THANK u



  6. #6
    New Member
    Join Date
    Feb 2002
    Location
    uk LONDON
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [quote]
    On 2002-02-26 16:03, rajface2face wrote:
    [quote]
    On 2002-02-26 15:50, gplhl wrote:
    On 2002-02-26 14:39, rajface2face wrote:
    thankx but i wanted to know hw do i record the number of items sold ie it should have number in stock n when each one item iz sold t should be recorded in n i wated to no how would this work. do u get wat i mean i mean the system it self should detect how many fonez sold n how many left not me entring the number sold
    for example the store has 6 nk 8310 mobiles n if one is sold than it should be detected that a item iz sold n needs to be reordere in other words it iz a AUTOMATED STOCK CHECKER. and i think just one formula would not be enough for this i think a couple of formulaes wll be required.
    THANK U hope 2 here soon from u.
    for a system to automatically detect that the phone is sold excel would somehow need to be linked in with your till?

    However you decide to do it, somehow something needs to trigger that there has been a sale and which stock item needs to have its stock count amended.

    How would excel knw that a phone has been sold?

    Exactly thats wat i mean. i t will be like a deals over phone like pp call in n order mobie phones. n when a phone has been sold than wat kind of macro or formula should i use to tell the systemm tat so n so item is sold i mean the system i am making is for the mnagr of the company n this system sholud have SUMIN so it can be told that this many of so n so item sold n the system is updated every week ie the maneger is told at end of the week that this many 8310s were sold n he keys tha in to keep a rec ord n i need help in every thing in this system i have writen. the whole program if u can give me n e ideas for this SPREADSHEET project 4 A level . THANK u

    i need help ASAP

    i think i neva made my self clear
    here is wat i wanted
    i want my sytem to be able to keep a record of the stock (all the diffrent mobiles) and i don't know how to do that on excel. i could have a list of all the items n next to each item i could have how many in stock n i could make a formula that every time a item is sold i click on its box n it minuses one from the stock. i guess u jknow wat kind of formulae i need n if u still don't understand please let me knoe ASAP
    thank u


  7. #7
    Guest

    Default

    [quote]
    On 2002-02-28 04:11, rajface2face wrote:
    [quote]
    On 2002-02-26 16:03, rajface2face wrote:
    [quote]
    On 2002-02-26 15:50, gplhl wrote:
    On 2002-02-26 14:39, rajface2face wrote:
    thankx but i wanted to know hw do i record the number of items sold ie it should have number in stock n when each one item iz sold t should be recorded in n i wated to no how would this work. do u get wat i mean i mean the system it self should detect how many fonez sold n how many left not me entring the number sold
    for example the store has 6 nk 8310 mobiles n if one is sold than it should be detected that a item iz sold n needs to be reordere in other words it iz a AUTOMATED STOCK CHECKER. and i think just one formula would not be enough for this i think a couple of formulaes wll be required.
    THANK U hope 2 here soon from u.
    for a system to automatically detect that the phone is sold excel would somehow need to be linked in with your till?

    However you decide to do it, somehow something needs to trigger that there has been a sale and which stock item needs to have its stock count amended.

    How would excel knw that a phone has been sold?

    Exactly thats wat i mean. i t will be like a deals over phone like pp call in n order mobie phones. n when a phone has been sold than wat kind of macro or formula should i use to tell the systemm tat so n so item is sold i mean the system i am making is for the mnagr of the company n this system sholud have SUMIN so it can be told that this many of so n so item sold n the system is updated every week ie the maneger is told at end of the week that this many 8310s were sold n he keys tha in to keep a rec ord n i need help in every thing in this system i have writen. the whole program if u can give me n e ideas for this SPREADSHEET project 4 A level . THANK u

    i need help ASAP

    i think i neva made my self clear
    here is wat i wanted
    i want my sytem to be able to keep a record of the stock (all the diffrent mobiles) and i don't know how to do that on excel. i could have a list of all the items n next to each item i could have how many in stock n i could make a formula that every time a item is sold i click on its box n it minuses one from the stock. i guess u jknow wat kind of formulae i need n if u still don't understand please let me know ASAP
    thank u

    i need help urgent

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •