Simple, need assistance

[craigwojo]

I've got a cell with the formula =ROUNDDOWN(M2*F2,2).
What I need is if the cell information is less that .75 I need it t
remain .75.

Thank you,
Crai

 

[Fredrik Wahlgren]

I've got a cell with the formula =ROUNDDOWN(M2*F2,2).
What I need is if the cell information is less that .75 I need it to
remain .75.

Thank you,
Craig

Like this?

=IF(M2*F2,2<.75,.75,ROUNDDOWN(M2*F2,2))

/Fredrik

 

[JE McGimpsey]

One way:

=MAX(0.75,ROUNDDOWN(M2*F2,2))

 

[Fredrik Wahlgren]

One way:

=MAX(0.75,ROUNDDOWN(M2*F2,2))

This solution, I have to admit, looks nicer.

/Fredrik