Results 1 to 10 of 41

Thread: copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-19-2020, 03:35 PM #15
    fixer
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0
    if column H of 1.xls is lower than column D of 1.xls then with column K do the subtraction after decimal and make it to the number ending with 0 or 5 whichever met first & if it ends with .05 or .00 then ignore that cell
    If column H of 1.xls is greater than column D of 1.xls then with column K do the addition after decimal and make it to the number ending with 0 or 5 whichever met first and if it ends with .05 or .00 then ignore that cell

    this is the conditon Doc Sir
    Last edited by fixer; 04-19-2020 at 03:40 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. VBA Simple Copy and Paste between two workbooks based on criteria
    By fixer in forum Excel Help
    Replies: 6
    Last Post: 08-28-2019, 09:42 AM
  3. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 01:38 PM
  4. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 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
  •  

Forum Rules