Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm very new to creating macro's. I've got a (maybe stupid question). I have the following situation: Basiscly what i want (what i would make of it) is the following code: Range("L45").Value = "Worksheets("Invulblad").Range("AA47").Value * L43" I want cell L45 to say: =0,05*L43 if AA47 on sheet 'Invulblad' is 0,05 and =0,00*L43 if AA47 on sheet 'Invulblad' is 0,00 Any help appreciated, Greets, Gunti |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
simple macro question | Excel Worksheet Functions | |||
question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
Macro question - I'm sure it's simple... | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |