Results 1 to 8 of 8

Combining MAX, ROUNDUP & IF for the same cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    9

    Question Combining MAX, ROUNDUP & IF for the same cell

    Hello!
    I am trying to create one formula (in one cell) so that it performs the following three things:
    1) Rounds any number to the nearest dollar
    2) Makes the minimum dollar value $2.00
    3) If another cell (G2) reaches $100.00 or more, I want it to revert to another cell's (B2) value.

    So, in essence, I want to combine the following two things:

    =MAX(2,ROUNDUP(F2,0))
    AND
    =IF(G2>="100",B2)

    I do not know how to correctly order these so that it performs all three things I'm looking for it to do. I've posted this before, but was given an answer that created a circular reference and did not make the minimum value $2.00.
    Any help would be appreciated!
    Thanks in advance!
    Last edited by babydee0413; 02-22-2010 at 02:51 PM.

Thread Information

Users Browsing this Thread

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

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