# Formula determined by Yes/No Dropdown

1. ## Formula determined by Yes/No Dropdown

Hi All -

I am EXTREMELY new to Excel and am having trouble with configuring what I need this job aid to do:

The attached sheet is to be used as an aid to determine pricing for a contract year with an annual percentage increase. The trick is, sometimes a particular coverage of "Cleaning" (Column C) does not receive the increase (I:1) that all the other coverage types receive.
I want users to be able to select from the drop down in (I:3) if the increase applies to the "Cleaning" coverage type but I cannot figure out how to work this or where to put any applicable formulas.

I think I need a formula in Column I that basically says the following:

IF I3 = YES, then determine the value of Column F x the increase percentage of (I:1), IF I3 = NO, then copy the annual value in Column F.

Any help or input?

2. ## Re: Formula determined by Yes/No Dropdown

Hi,
1. Does your formula need to be per line? Sometimes the cleaning increase will apply and sometimes not?
If so - you need to open a column and add YES/NO per line.
2. where do you want your formula to be? Is it instead of an existing one or do you want to create a new claculation on top of what you already have?

3. ## Re: Formula determined by Yes/No Dropdown

``Please Login or Register  to view this content.``
If per row, then replace \$I\$3 to refer to the yes/no cell in the current row...

4. ## Re: Formula determined by Yes/No Dropdown

1. It would only apply to the "Cleaning" lines.
2. I think I would need to be instead of an existing calculation in Column I, but I'm not entirely sure it is possible? This would only apply to any cells that say "Cleaning" in column C, not per line. So basically:

IF column C says "Cleaning" and I:3 says "YES" , multiply the value of F*I:1 to determine the value of I.
IF column C says "NO" and I:3 says "NO" , copy the value of F.

5. ## Re: Formula determined by Yes/No Dropdown

Try:
``Please Login or Register  to view this content.``

6. ## Re: Formula determined by Yes/No Dropdown

I was able to use this in conjunction with the existing formula in Column I to apply to all situations I needed. Thank you so much for the help and your patience!

There are currently 1 users browsing this thread. (0 members and 1 guests)