Results 1 to 5 of 5

Automatically extract numbers divisbible by 10 wholly

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2023
    Location
    Pakistan
    MS-Off Ver
    Office 365
    Posts
    2

    Lightbulb Automatically extract numbers divisbible by 10 wholly

    I Have attached a screenshot for understanding.

    I have a sheet of investment plan.

    The condition is investment can only be made at multiple of 10s (Eg 200, 210, 220, 230, 240, 250).
    Investments cannot be made in decimals or in number which is not wholly divisible by 10 (Eg 204.5, 205 , 208.9)
    Eg:
    Original Investment was $324
    But I can only invest $320 (324 it is not divisible by 10)
    I earned at 7 %. Therefore, (320*7%=22.4)
    Revised Investment = 324 + 22.4= 346.40

    Now, next time I can invest is only $340 and not $346.40 (6.40 cannot be invested)
    My question is How I can automate this "Invested number in excel" i.e (if it is 324, excel automatically gives 320 and if it is 345.54 excel automatically gives me $345.


    I have also attached excel file for reference. This sheet is made manually as it is difficult to ascertain formula.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract numbers on the left in a string that also contains numbers on the right
    By Sybille in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-27-2022, 10:01 AM
  2. Extract all numbers from string, returning numbers to individual cells
    By LJBOS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2020, 08:46 AM
  3. Spreding a number wholly and equally over a fixed number of cells
    By ABEN1 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-12-2019, 04:44 PM
  4. Spreding a number wholly and equally over a fixed number of cells
    By ABEN1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2019, 02:12 AM
  5. [SOLVED] Extract the text and numbers basis on specific numbers included
    By Neilesh Kumar in forum Excel General
    Replies: 6
    Last Post: 08-26-2018, 01:34 PM
  6. [SOLVED] how to extract unique numbers once from a list of repeated numbers?
    By stuart.kwok@gmail.com in forum Excel General
    Replies: 2
    Last Post: 05-02-2006, 11:20 AM
  7. [SOLVED] How to lock a file (wholly or partly)
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 1
    Last Post: 11-27-2005, 05:20 PM

Tags for this Thread

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