Consulting

Results 1 to 3 of 3

Thread: Solved: Formula help

  1. 08-10-2010, 07:23 AM #1
    austenr
    austenr is offline
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Solved: Formula help

    What is the correct syntax for this:

    [VBA]=if(Age>65 and SPAge < 65,"Split Coverage","")[/VBA]
    Peace of mind is found in some of the strangest places.
    Reply With Quote Reply With Quote
  2. 08-10-2010, 07:53 AM #2
    GTO
    GTO is offline
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Hi Austin,

    I believe its:

    =IF(AND(Age>65,SPAge<65),"Split Coverage","")

    Have a great day,

    Mark
    Reply With Quote Reply With Quote
  3. 08-10-2010, 07:57 AM #3
    austenr
    austenr is offline
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Thanks Mark. good to go.
    Peace of mind is found in some of the strangest places.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules