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

**Hawk77** · 03-25-2013, 01:02 AM

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

**arlu1201** · 03-25-2013, 01:10 AM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Tayjayt** · 03-25-2013, 01:16 AM

Try these out:

1. In cell N8
=if(o8="M",61*12,if(o8="A",61*1,61))

2. In Cell R10
=if(B10="MASA",Q10,if(and(B10="M-LTC",Q10*.5<350),Q10*.5,if(B10="M-LTC",350)))

3 In Cell R8
=if(and(B8="UTA-CAN",Q8*12/9<350),Q8*12/9,if(B8="UTA-CAN",Q8*12/9,'whatever value if not either')

**Tayjayt** · 03-25-2013, 01:17 AM

Sorry, 3 should have another close parentheses [)]at the end

**arlu1201** · 03-25-2013, 01:30 AM

Tayjayt,

Its possible you didnt refresh your page before putting in the solution. However, for future reference, check forum rule 7 -

Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc