if function

[workshop]

How do I create the if funtion that if
field A Field B Field C
a 10
b 5
c 10
d 8

I like to make Field C that if field A is a then field B*.2, if field A is b then field B*.4, so on
Please help
Thanks

 

[D0N]

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.