Thread: Result not greater than .............
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Result not greater than .............
=MIN(A1*B1,B1*.05) or
=B1*MIN(A1,0.05)
--
David Biddulph

Donna wrote:
A B
10.000 1,262.61
What is the formula for saying A * B but not greater than B * .05


Reply With QuoteReply With Quote