# Thread: Excel formula (MS office 2007)

1. ## 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. ## 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))

3. ## 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. ## 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.

5. ## 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
•