Results 1 to 7 of 7

And formula inside an if formula in a macro

Threaded View

Jessica.Bush And formula inside an if... 08-21-2010, 05:04 PM
tigertiger Re: And formula inside an if... 08-21-2010, 05:33 PM
Jessica.Bush Re: And formula inside an if... 08-21-2010, 06:09 PM
tigertiger Re: And formula inside an if... 08-21-2010, 06:29 PM
Jessica.Bush Re: And formula inside an if... 08-21-2010, 06:49 PM
tigertiger Re: And formula inside an if... 08-21-2010, 07:08 PM
Jessica.Bush Re: And formula inside an if... 08-22-2010, 01:20 PM
  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    178

    And formula inside an if formula in a macro

    Hi all,

    I have a two columns of values and normally I would just use an 'if' formula with 'ands' etc in it to calculate the value of my third but I do not know how to write this into a macro and am hoping someone could help please?

    Essentially the bit I am having trouble with is:

    ' if cell "A3" = 2 and cell "B3" <>2 Then cell "C3" = "Second".

    There is more to it but this is the bit I am stuck on and I am hoping someone could help me with please?

    Many thanks for your help.
    Last edited by Jessica.Bush; 08-22-2010 at 01:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1