ValueMath ( List1 ; List2 ; operation )
Do mathematical calculations on corresponding members of two value lists
Average rating: 3.3 (4 votes) Log in to vote
ValueMath ( "8¶7¶6¶5" ; "6¶5¶0¶20" ; "/" )
ValueMath ( "8¶7¶6¶5" ; 2 ; "^" )
ValueMath ( "8¶7¶6¶5" ; "" ; "^" )
1.333...¶1.4¶?¶.25 --note: divide by 0 gives ?
Result: 64¶49¶36¶25 --note: acts like Extend
Result: "" --an empty value list results in an empty result
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Use two value lists and multiply/divide/add/subtract/(raise to power) them together, value position by value position
The result is a new value list with the results of each math manipulation
Note: If one List is only one member long, this function will work like Extend, i.e., apply that value with operation to all members of other list
Note: If both lists are >= 2 members long but are not the same length, concatonate the longer list
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.