Results 1 to 11 of 11

Using "If" and "And" in a formula to return a value/number

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2008
    Location
    maryland
    Posts
    23

    Using "If" and "And" in a formula to return a value/number

    I hope this is the correct place to post this and if it isn't I apologize in advance. I have included a small sample of the spreadsheet I'm trying to use in a larger one.

    The goal is simple, "If" you select "Yes" to Health insurance, "and" if you select "HMO", I'd like to have the cost for the "HMO" returned in the "Health Cost" cell. The same would hold true for "POS" with the returned cost being the one for "POS." I have started what I think is the right way to do this but so far it's just returning "True" or "false". I didn't go any further with the formula given the simple aspects are not working yet.

    Thanks in advance,

    Ed
    Attached Files Attached Files

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