+ Reply to Thread
Results 1 to 13 of 13

Help!! 2/10, Net 30 formula?????

  1. #1
    Registered User
    Join Date
    03-08-2022
    Location
    La Grange NC
    MS-Off Ver
    365
    Posts
    2

    Help!! 2/10, Net 30 formula?????

    Help! I took Excel over 8 years ago and can't remember much, plus it's newer and better now, too. How do I show these Terms: 2/10, net 30? I'm at a loss. Next question is will it show the discounted and net amount in the same block?
    Please, please help!!!

    Granny

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    I do not understand what you want.

    Please read the yellow banner (top) and attach a file that meets its guidelines.

    Also, your title is pretty poor. Once i understand what you want, I will (on this occasion) change it for you..

    A good title should read like a Google search term.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    03-08-2022
    Location
    La Grange NC
    MS-Off Ver
    365
    Posts
    2

    Re: Help!! 2/10, Net 30 formula?????

    Thank you Glenn for responding. I don't think this 'forum' is for me if you don't understand what 2/10, Net 30 means. Thank you for your time though.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    Suit yourself. I just don't understand what you expect to see...

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Help!! 2/10, Net 30 formula?????

    @Granny

    An explanation as per attached would have helped:

    https://tipalti.com/en-uk/210-net-30...20a%20discount.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    There are very few analytical chemists who would know what 2/10 net 30 means.

    Oh well, you can't please them all. I suspect Elvis has left the theatre...

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Help!! 2/10, Net 30 formula?????

    @Glenn: translating from the article to Excel is hardly degree-level computation !!!

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    True, but expecting everyone to know what the jargon means IS unrealistic... and the OP's explanation and attitude did leave something to be desired. feel free to help.

    I, however, am "out".

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Help!! 2/10, Net 30 formula?????

    Agree with your sentiments entirely (as "2/10 Net 30" was "foreign" to me too: and I suspect to the majority of contributors). QED.

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    Oh. I always thought you were "something financial". Aren't you??

  11. #11
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Help!! 2/10, Net 30 formula?????

    No ..... so i'll keep you guessing!

    But many, many years ago I was looking at a career in Chemistry but I wasn't clever enough! so I found (or rather fell into) another career.

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Help!! 2/10, Net 30 formula?????

    Hahaha. I fell into Chemistry 'cos I wasn't brave enough to pursue the career I really wanted to follow: as a war correspondent for a Broadsheet newspaper. If you remember him... Robert Fisk was my role model.

  13. #13
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Help!! 2/10, Net 30 formula?????

    Blimey! I don't believe there are many people who would choose "war correspondent" as a career. I vaguely remember the name Robert Fisk but no more.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1