View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GoofyinNY
 
Posts: n/a
Default min or max results

I am trying to include minimum and maximum totals for a customer billing
spreadsheets, B8 and B13 are numbers and I need a minimum of 10.00 and
maximum of 100.00 to be included in the following formula.

Thanks !!

=PRODUCT(B8, B13/100)