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.