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


"JE McGimpsey" wrote in message
...
One way:

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

In article ,
craigwojo wrote:

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


This solution, I have to admit, looks nicer.

/Fredrik