Hi All,
I have used the below function called CalcValue in VBA to test more than 7 conditions, and each condition if true will return a different value.
This function accepts as a parameter a cell and returns a value based on a complex IF THEN ELSE statement.
Macro Code:
The macro code looks like this:
Please Login or Register to view this content.
My question is, how do I set the value returns to "other words" if all the conditions are tested? Please refer to my attached file for better understanding. Thanks a million
Bookmarks