Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
if function
- Thread starter workshop
- Start date
The less messy way is to make your result a calculation which, using your example, is:
Case
(
C = a, b * .2,
C = b, b * .4
)
Keep adding more of these as needed. You can (and should) have a default value at the end if C can ever have an upredictable/unchecked-for value.
Case
(
C = a, b * .2,
C = b, b * .4
)
Keep adding more of these as needed. You can (and should) have a default value at the end if C can ever have an upredictable/unchecked-for value.
- Status
Similar threads
