Formula

Pooja

Like Don says, you need to change your sub fields to be type formula numeric l and then change the formula to take the numerical values out of quotes.  Also unlike Excel it is not necessary to nest your IFs.  Lastly when writing an IF formula  I suggest a vertical appearance for better readability

If(
[Probability Of Occurrence]="Very Low (1-9%)",1,
[Probability Of Occurrence]="Low (10-29%)",2,
[Probability Of Occurrence]="Medium (30-50%)",3,
[Probability Of Occurrence]="High (51-70%)",4,
[Probability Of Occurrence]="Very High (71-99%)",5)


Then for your final field you can have the formula similar to your post

[Probability] * ([Probability + [Cost])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------