Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Well, what I want to do is edit if a particular cell has a particular value.

For example, if cell A18 has any number higher than 6, it will make the value of cell O2 say =A18*0.5, however, if it says 6, O2 will say =A18*0.6.

Do you understand what I am talking about? If you are, can you please find a good macro to do this?

Thanks, all hope appreciated. :)

share|improve this question
Google something like "excel write formula into cell from macro". My first hit gave the answer –  Jan Doggen May 6 '13 at 7:22
What do you mean by first hit exactly? –  Mordecaii May 6 '13 at 7:27
First Google search result. And I said 'my' because Google tailors search results for individual users, so your results may differ. Anyway, that URL was ozgrid.com/forum/showthread.php?t=61884 –  Jan Doggen May 6 '13 at 8:04
Yes, that was mine as well. However, I want an if in the macro code, not in the function, but I'm gonna try doing that. –  Mordecaii May 6 '13 at 8:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.