| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
include maximum number in fomula
I have a formula
=sum(t2*.01*v2) I want the maximum result to be $1500.00 |
|
#2
|
|||
|
|||
|
=MAX(1500,sum(t2*.01*v2))
-- Regards, Peo Sjoblom "jv" wrote in message ... I have a formula =sum(t2*.01*v2) I want the maximum result to be $1500.00 |
|
#3
|
|||
|
|||
|
"Peo Sjoblom" wrote: =MAX(1500,sum(t2*.01*v2)) -- Regards, Peo Sjoblom "jv" wrote in message ... I have a formula =sum(t2*.01*v2) I want the maximum result to be $1500.00 |
|
#4
|
|||
|
|||
|
That's a MIN instead of MAX
-----Original Message----- =MAX(1500,sum(t2*.01*v2)) -- Regards, Peo Sjoblom "jv" wrote in message ... I have a formula =sum(t2*.01*v2) I want the maximum result to be $1500.00 . |
|
#5
|
|||
|
|||
|
One way:
=MIN(1500,T2*V2*0.01) Note that your SUM() is superfluous - it returns the same value as =t2*0.1*v2 In article , "jv" wrote: =sum(t2*.01*v2) I want the maximum result to be $1500.00 |
|
#6
|
|||
|
|||
|
I'm sure Peo meant "MIN", not "MAX"
In article , "Peo Sjoblom" wrote: =MAX(1500,sum(t2*.01*v2)) |
|
#7
|
|||
|
|||
|
Thank You
JV "BobT" wrote: That's a MIN instead of MAX -----Original Message----- =MAX(1500,sum(t2*.01*v2)) -- Regards, Peo Sjoblom "jv" wrote in message ... I have a formula =sum(t2*.01*v2) I want the maximum result to be $1500.00 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of worksheets | Excel Worksheet Functions | |||
| Can auto number (or OFFSET) include letters? | Excel Worksheet Functions | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| only include cells beginning with specified character or number | Excel Worksheet Functions | |||
Linear Mode
