Results 1 to 7 of 7

Help! Roundup/round down depending on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2016
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    4

    Help! Roundup/round down depending on cell value

    Hi all, this is the first time I've used this forum, so please bear with me while I try to explain what I need.

    What I want is a formula for B1 and B2 which is 50% of A1 and A2 and if the value of A1 is not divisible by 2, but A2 is divisible by 2, then both B1 and B2 round up and vice versa. However, if neither A1 nor A2 are divisible by 2, i need B1 to round down and B2 to round up. Is this possible? I hope I've explained it clearly. Please see attachment. Thanks in advance for any advice.
    Attached Files Attached Files
    Last edited by nicolam_83; 02-16-2016 at 05:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] formula to roundup o rounddown depending on value
    By JC25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2013, 08:42 AM
  2. [SOLVED] Round, Roundup, Rounddown or something else????
    By PERE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 09:14 AM
  3. Using ROUNDUP and a Minimum value (that doesn't round) in the same function.
    By Stahlfeder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2012, 06:43 PM
  4. Combining MAX, ROUNDUP & IF for the same cell
    By babydee0413 in forum Excel General
    Replies: 7
    Last Post: 02-22-2010, 03:13 PM
  5. Roundup a cell with a formula
    By bamroll in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-16-2009, 04:04 PM
  6. Round one cell depending on value of another
    By SueJB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2006, 06:25 AM
  7. [SOLVED] Roundup or Ceiling Function to round to a specific number
    By Angie33 in forum Excel General
    Replies: 18
    Last Post: 06-29-2006, 12:50 PM
  8. [SOLVED] How can I roundup a cell that already has a formula in it?
    By Timsalive in forum Excel General
    Replies: 1
    Last Post: 06-22-2006, 07:45 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