I'm trying to create a formula that calculates a dollar amount based on a key field.  The key fields have different values.  Some are zero, some are 160, some are 250.  And I have about 50 key fields to calculate.

I had no trouble creating the first If Then formula..

If {SERVICE_TYPES.SE_KEY} = 2 Then
    {WORK.WO_WORK_HOURS} * 0
Else
    {WORK.WO_WORK_HOURS} * 0

I'm not sure how to continue from here.  I have 3-57 still to use.  I work for a service company and we are trying to create a report that calculates a dollar amount for hours worked based on our normal hourly rates.  We also have contracts and warranty rates that will be at zero.  In the example above that "2" would represent a warranty job.

Sure,

I have a piece of hardware that we have done service on for 1 year.  Let's say there are 10 jobs on it.  We have different service levels depending on the equipment, some cost more for service than others but it is only 2 tiered pricing....$160 per hour or $250 per hour. 

So, let's say that of these 10 jobs 6 of them were done under the warranty...and this is what we call our Premium equipment service level.  So the other 4 jobs would be billed at $250 dollars an hour.

In our database the service types table looks like this:

SE_KEY  SE_DESC
2             Standard Contract Service
3             Standard Hourly Time and Material
4             Premium Contract Service
5             Premium Hourly Time and Material


So, I'm trying to use the SE_KEY data to string together a series of IF Then statements to calculate the correct charge for each job.

Yes, this looks like what I need.  Can I put more values in the brackets:

if {SERVICE_TYPES.SE_KEY} in [2,4,6,18] then 0 else

Like that?

Ah, one more thing with this.  This standard or premium service charge needs to be multiplied by the hours actually worked on the job.  They are contained in {WORK.WO_WORK_HOURS} .

So would it be:
if {SERVICE_TYPES.SE_KEY} = 3 then {WORK.WO_WORK_HOURS} *160 else