Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Browse other questions tagged .