+ Reply to Thread
Results 1 to 2 of 2

If then for multiple arguments

  1. #1
    Registered User
    Join Date
    01-23-2005
    Posts
    42

    If then for multiple arguments

    I need this as a formula but I don't know the syntax for multiple arguments in an if then statement:

    If the text is "January","April","July", or "October" then do A
    If the text is "February","May","August" or "November" then do B
    Otherwise Don't do anything.

    Any help is greatly appreciated :-)
    Last edited by dwest100; 09-07-2010 at 10:19 PM.

  2. #2
    Registered User
    Join Date
    01-23-2005
    Posts
    42

    Re: If then for multiple arguments

    Rephrasing the question...

    I have this and it works:

    F57-F20-(F53+F47+F41)+IF(TEXT(ReportDate,"mmmm")="July",TwoThirdsOfProratedFee,OneThirdOfProRatedFee)

    But I need it to check for "January" "April" "July" or "October"

    How can I do that?

+ Reply to Thread

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