View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Simple, need assistance


"craigwojo" wrote in message
...

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