Not sure if this is possible?

[rickwardyy]

Ok so in cell I6 if it contains the word ‘’bottom’’ I need a sum in cell O3 to work out 50% of cell I7.. if it contains the word ‘’Middle’’ I need it to work out 75% of cell I7 and finally if it says ‘’top’’ to work out 100% of cell I7..

Is that possible?

Cheers!

 

[63falcondude]

How's this?

Excel 2010
	I	J	K	L	M	N	O
3							50
4
5
6	bottom
7	100
Sheet1

Cell Formulas
Range	Formula
O3	=IF(I6="bottom",I7*0.5,IF(I6="middle",I7*0.75,IF(I6="top",I7,"")))

 

[FDibbins]

Another option...
=iferror(I7*CHOOSE(MATCH(A3,{"Bottom","Middle","Top"},0),0.5,0.75,1),"")