I am looking for a macro that will insert a formula based on specific criteria, the criteria are listed below. I am very new to VBA and am just after a code that I can look at then attempt to work out whats going on in the code and prehaps modify it to suit my needs. Your help is greatly appreciated.

WHAT I WOULD LIKE THE MACRO TO DO
Strating from row 5
look in cell E5 if there is a numeric value then insert the following formula into cell F5 "=C6*$G$1" otherwise leave blank

Strating from row 5
look in cell E5 if there is a numeric value then insert the following formula into cell G5 "=(F6*H6)/100" otherwise leave blank

Strating from row 5
look at cells b,c and d if b is > 1, if c is > 1 and if d isblank then insert a sum into F5 (the sum adds up the range of cells above it with a numeric entry, the sum range stops when a blank cell is encountered)

Strating from row 5
look at cells b,c and d if b is > 1, if c is > 1 and if d isblank then insert a sum into G5 (the sum adds up the range of cells above it with a numeric entry, the sum range stops when a blank cell is encountered)