I need an If formula for the following...
If [field1] is equal to "CCO" then [field2]*.52
If [field1] is equal to "ASG-F" then [field2]*.20
If [field1] is equal to "ASG-K" then [field2]*.80
else [field2] is 0 or blank
Sorry but I am terrible at figuring out formula structures :-(
Mark Comish
Mark