Forum Discussion
Subtract specific amount to multiple cell if condition met
Hi, I have a list of numbers in a column (let’s say B1 to B10) and I want to apply a correction to all of them if a condition is met. E.G: If A2 is Yes, I want to apply a -3 correction to my number...
a simpler way is by VBA.
pls see attached file.
hope that you can work something out of it.
thanks..
- Oh, i’ll Try that! Thank you!
- your feedback will be appreciated..
Hi Lorenzo,
Looks like it's doing a pretty good job, but i would like it to be automated. If A2=Yes, automatically substract X (no prompt). I would also like to add an A3 cell with same kind of criteria, to also make a correction to my B1:B10 cells. The can be cumulative if both conditions are met.
Sorry i have to ask but i know nothing about macros and VBA. Maybe you know a good website that explains the basics so i can figure it out by myself.
Thank you
