macro for nested if formula where result depends on text and number values from different columns

[CorrectBalance]

Hi everyone,

I ma using excel enterprise 2007.

I run in to problem with my current work. I have tried to write a macro for nested if formula and used several different examples of those from internet including some from this forum, however those where not exactly relating to my problem.

I am complete novice in terms of macros and vba.
I would like to input number in column c but that number has to be based on text input in column f and some number will have to check if value in column h is above 0

Example:

nominal	description	out	in
	paypal transfer		5000
	post office	190

<tbody>
</tbody>

In column named "Nominal" I have to put numbers as such: 4000 - for paypal transfer provided that column "in" >0 ; and 5100 for post office provided that column "out" >0

I have more than 5000 transactions in there (rows) and description will vary a lot. I would like a template of macro which I could fill in with appropriate text from description and numbers I need in Nominal to run through entire worksheet. I also want that macro to run only when I press run macro. I do not want number in nominal to change on its own if I move value from "in" to "out" or vice versa.

Help please.