Results 1 to 5 of 5

Cetain cell to equal #*12 if "M" or #*1 if "A" and other questions

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    TX
    MS-Off Ver
    2000
    Posts
    1

    Cetain cell to equal #*12 if "M" or #*1 if "A" and other questions

    Excel Spread.pngThanks for having this forum. I have searched but I don't know how to search for something I don't know how to do so any help would be appreciated.
    This is for a spread sheet for figuring my payout on insurance
    1. if O8 is "M" then N8 needs to be *12, if 08 is "A" then N* needs to be *1
    2. I have a drop down box in B10, based on what that drop down box is I need Q10 to be *.XX (Example if B10 is MASA then it needs to be *.4, if B10 is M-LTC then it needs to be *.35) etc.
    3. Drop down box again. (These are based on 12 months of premium)
    a. If B10 is MASA then I need R10 to equal Q10. (Pays 12 months up front)
    b. If B10 is M-LTC then I need R10 to equal half of Q10 but nothing greater than $350 (Pays 6 months up front)
    c. If B8 is UTA-CAN then I need R8 to equal (excel formula that I know) =Q8*12/9 but nothing greater than $350 (pays 9 months up front)

    I really hope I have made my desires clear in the questioning. If not, I do apolgize.

    I tried to attach a pic of the areas i'm working with so hopefully it took

    Thanks,
    TG
    Attached Images Attached Images
    Last edited by Hawk77; 03-26-2013 at 12:18 AM. Reason: Admin told me too (so did the rules)

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