D
dmax function
I have developed a spreadsheet that computes profits using an input of nine
variables using the rand and vlookup function to indicate the values of these
variables inputted used to calculate profit. My question however is on dmax
function. How do I use dmax to calculate the maximum profit where the
criterion is a certain indicated variable. For instance, useful life is one
variable I want to find the maximum profit that correlates with a uselife of
5 years as indicated in one column. Any help would be appreciated. Thanks
in advance, Chris
variables using the rand and vlookup function to indicate the values of these
variables inputted used to calculate profit. My question however is on dmax
function. How do I use dmax to calculate the maximum profit where the
criterion is a certain indicated variable. For instance, useful life is one
variable I want to find the maximum profit that correlates with a uselife of
5 years as indicated in one column. Any help would be appreciated. Thanks
in advance, Chris