I know this, the reason i'm asking such a simple question is because i now
can modify the formula given to my needs (I don't want the formula part in
excel to be filled).

Grtz & Thanks,
Gunti

"John" wrote:

Hi Gunti
I know your asking for a macro but a simple formula will do the same
=IF(A1="x",A3*0.5,"") if no"x" show nothing.
HTH
John
"Gunti" wrote in message
...
Hi,
I want to create a very simple macro and i'm having trouble finding it on
the internet.

I basicly want the following formula:

If Range(a1) = "x" Then
Cell A2 = "Cell A3*0.5)

I am completely new to creating macro's (as you can see).
Any help is appreciated

Gunti