Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions |