View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default If Formula - Help

Carrie,

=MIN(B4/B5,160)

Mike

"Carrie" wrote:

I'm not sure if I'm using the right formula but this is what I need:

I need the the total of b4/b5, if that equals 160 or more I need it to show
160, if it's 159 or less I need that value to show.

Thanks