Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel formula (MS office 2007)

    Any help on the following formula is appreciated. I want the formula to produce the result as written except with a $1.00 minimum.
    =IF((F5*F1)+F5,ROUNDUP((F5*F1)+F5,1)-0.01,0)

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Excel formula (MS office 2007)

    Hi Bill,

    You could simply add a MAX function:
    =MAX(1,IF((F5*F1)+F5,ROUNDUP((F5*F1)+F5,1)-0.01,0))
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Lounger
    Join Date
    Sep 2008
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel formula (MS office 2007)

    Combining MAX with the logic of the IF would give

    =MAX(1, ROUNDUP((F5*F1)+F5,1)-0.01)

  4. #4
    Star Lounger
    Join Date
    May 2007
    Location
    California, USA
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel formula (MS office 2007)

    Hi Paul and mikerickson,

    Thanks for you replys.

    I failed to explain with any clarity what I'm trying to do. Sorry!,
    I want to put a formula in cell F6 that would return the mark up in cell F1, but never under a $1.00 minimum. If the GP got under $1.00 then the formula would return the $1.00 minimum.

    Hope this makes sense. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Oops! the file.
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel formula (MS office 2007)

    This? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    =IF((F5*F1)+F5,MAX(ROUNDUP((F5*F1)+F5,1)-0.01,1),0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •