fill empty with two condition

Please Login or Register  to view this content.

dear friends above macro work fine for me.i need to add two conditions to that macro.it's like this.
01.if Column "G" value " TP " & Column "H" value " 150D " then above 1.5 should change to 0.9

Please Login or Register  to view this content.

02.if Column "G" value " PP " & Column "H" value " 16/2 " then above 1.5 should change to 1

Please Login or Register  to view this content.

Column "G' & column "H" values other than above then 1.5 is correct.

Please Login or Register  to view this content.

pls anybody can help me to do that......

Maybe this:

Please Login or Register  to view this content.

thank u very much JBeaucaire.your understanding is 100% correct,your macro very well.thanks a lot again....