Hi Nil,
If you don't have a lot of options to code for you can nest the IF statements like:
=IF(B2="Dragon",40,IF(B2="Tiger",60,IF(B2="Adult",80,)))
If you have many more IF's to nest then I would recommend making a look up table and using a VLookup function or Index & Match.
With the Vlookup you would create a range of cells containing the field values (Dragon, Tiger, Adult) down one column and in the next column to the right put the values 40, 60, 80.
hth
If you don't have a lot of options to code for you can nest the IF statements like:
=IF(B2="Dragon",40,IF(B2="Tiger",60,IF(B2="Adult",80,)))
If you have many more IF's to nest then I would recommend making a look up table and using a VLookup function or Index & Match.
With the Vlookup you would create a range of cells containing the field values (Dragon, Tiger, Adult) down one column and in the next column to the right put the values 40, 60, 80.
hth