seemingly simple custom function

[cwunderlich]

Here is what I have:

one column with unlimited incurred values by PY, next to that column is a another column with losses in excess of a certain retention by PY (if any).

I want a function that can return the max of the [unlimited incurred minus the excess losses, (if any) ] i.e. the max of the capped losses.

Any ideas??

Thanks!

 

[cwunderlich]

or is there a way to have a function use a range as an input and then put each cell value within that range into an array??

 

[cwunderlich]

anyone???

 

[cwunderlich]

pretty please??