Creating an excel formulae with multiple options

I am trying to creeate a spreadsheet which will work out a certain value for myself. 

I am trying to figure out how I can do the following:

If (such a cell)= the letter A and (such a cell)= a number between 0-99 then times a value placed in another cell by a percentage in another cell. 

So let me explain with the picture below. If the ‘Value’ is 99 and the ‘Letter’ is A then I want it to times the percent which is on the table below (0.14%) by the ‘value’. Obviously there are many differant scenarios that i would like for the spreadsheet to be able to work out, for example, placing 1000 and the letter B in the box and it to work out a total value.

By: Joe

Leave a Reply

Your email address will not be published. Required fields are marked *