View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bhupinder Rayat Bhupinder Rayat is offline
external usenet poster
 
Posts: 64
Default Function - array with 2 variants

HI all,

I want to write a function that takes an array with 2 optional values (e.g
op1 and op2) and returns an array with each value less than op2 replaced by
the op2 value, and each value higher than the op1 replaced by the op1 value.

Can anyone help?

Thanks in advance.

ss