Excel formula (MS office 2007)

Topic

New Reply

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)

Reply | Quote

Replies

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
[Fmr MS MVP - Word]

Reply | Quote

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.

Oops! the file.

Reply | Quote

This?

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

Reply | Quote

Combining MAX with the logic of the IF would give

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

Reply | Quote