How to fill a cell with formula if condition fulfilled
Hello masters,
I need help, I need vba code to do this:
If I enter value on column C1 and D1 then I would like column E1 automatically filled with formula like "=(C1*D1)-((C1*D1)*10%)" and so with the next row but only if i enter the value on c and d, if nothing entered then the formula is not needed.
Please help me.
Thank you
You could try a formula like this
Don't know what your decimal separators are "," or "." or if you use ";" or "," but I guess the later. Test if it works.
Please Login or Register to view this content.
Alf
Last edited by Alf; 02-07-2013 at 03:21 AM. Reason: modify for negative values
thank you for your reply mr. Alf, I don't want to put the formula manually on the cell I want to use vba code to insert the formula and copy the validation from row above.
would you please help me with that?
Well then you could try a macro like this.
AlfPlease Login or Register to view this content.
Last edited by Alf; 02-07-2013 at 06:26 AM. Reason: trimming formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks