Function 06)

06) Add Function DeCode

Using the function

= DeCode( SearchValue , YourDefault , ValueOne , ReturnOne ,
ValueTwo , ReturnTwo , ….)

You can specified paired values. This works similarly to Oracles DECODE function with the main difference being that a default is required and is the second argument.

This formula:       =DECODE(F60,”My Default”,”Bob”,40,”Jerry”,55,”The Wizard”,50)
Would return:      50

If Cell F60 contained the string ‘The Wizard’

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc