Hi
I need to write a formula which would refer to a table with a calculation
depending on what I entered in the first cell. It is a table which will
minus a percentage depending on what the margin class number ( 22 - 4)
e.g.
A1 B1 C1 A1 B1 C1
£24.99 - 19 (75%) = £6.247 or £24.99 - 14 (52%) = £11.995

I created the table to do the equation however I need an 'IF' formula which
states, 'if B1 contains '16' refer to cell E4' which has the formula in or
'if B1 contains '19' refer to cell E7' hence subtracting the percentage to
give me the result in cell C1

Any help or guidance would be greatly appreciated.