Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min or max results
Try this:
=MAX(10,MIN(B8*B13/100,100)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "GoofyinNY" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min or max results
=MAX(MIN(PRODUCT(B8, B13/100),100),10)
odd as it may seem, the MIN statement ensures the max figure, and vice versa. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "GoofyinNY" wrote in message ... 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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min or max results
Let's see if I understand you correctly....
Try this: =MIN(MAX((B8*(B13/100)),10),100) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "GoofyinNY" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find multiple results | Excel Discussion (Misc queries) | |||
Appending Random Results? | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) |