|Assuming that A1 will always contain one of the three values mentioned, the formula can be shortened to:|
Since FL and NL both result in B1*10, you can OR those conditions instead of checking for them individually.
Since there are only 3 choices to choose from (assumed) then if A1 is not FL or NL, it must be BL. Therefore there is no need to actually check for BL with an IF function.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.