Results 1 to 15 of 15

Round UP for Cut Materials

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Sydney
    MS-Off Ver
    365
    Posts
    16

    Round UP for Cut Materials

    Hi folks,


    I need to a help to round up or down (depend on the number) all the numbers different than 150,200,250,300,450, 600 on the collums E and F
    Also, use these new values on the formula =COUNTIF(E4:E11,"300") to show how many of these numbers I have on E8.
    per example: on E10 i have 340 and I`d like to change this number to 450, only to use 450 to count on I9,
    the problem is that I dont wanna show the round up value on E10, i wanna keep same.

    to clarify we have this na, pa sizes standarts 150,200,250,300,450,600. When we have an order that require us to cut these material we do but we need to deduct from the standart size.




    thanks in advance
    Attached Files Attached Files
    Last edited by vini.v4; 11-12-2019 at 06:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Custom formulas that will round up when a condition is met or round down
    By cinstanl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2016, 01:32 PM
  2. Replies: 5
    Last Post: 01-30-2015, 11:34 AM
  3. Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  4. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  5. [SOLVED] Conditional Round up or Round up Function
    By cdmterence in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-18-2013, 06:03 PM
  6. Counting to a specified numberin round, then add one to round
    By McG_84 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-10-2013, 04:20 PM
  7. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

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