View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default custimise the "IF" formula function

I am trying to write a UDF that will let me make my own customised IF
formula

I have my customised part working fine, but do not know how to do the
code for the IF part of the function. This part i want to act exactly
like the ordinary IF formula from the worksheets.

Can anyone tell me how to write the code for the IF formula?

I can input the values ok (If_test, If_True, If_False), but when it
comes to the cell value displaying the results, i cannot change the
cell.value as this will then remove the formula.

any help or guidance appreciated.
George