nested if stament

  1. J

    If Statement - If false, then check next cell

    I'm creating a function that needs to find if a name in one cell (E3) matches a name in a list of cells. I have two formulas I've tried to use but neither is quite right. Formula 1 could work, but it'll take forever to write all of the nested if statements (and it would be difficult to add new...
  2. M

    Combining auto suggest combo box and auto population using if statement

    I am trying to combine these 2 code lines to accomplish a drop down list with suggestive text. That also auto populates other cells when a menu is selected it populates menu items. The suggestive text works well but I'm a bit stumped on how to go about adding the auto population of the cells...
  3. T

    Nested if statement that adds

    Hello Board, I need I think a nested if statement that adds overtime. I have 5 columns and 25 rows. Each row has a field that calculated 5 different column of time to figure out overtime. Any of the 5 cell that hold hours over 40 need to calculate the over 40 number as overtime. The formula...
  4. J

    Lengthy If Statement interpretation - HELP!

    Hello! In layman's terms, would anyone explain how this formula operates? Forgive me I think I cut off the ending part -- which is only missing a few closing parenthesis.... =IF(ISERROR(VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report Contract...
  5. M

    highlight a cell if 2 conditions are met - looping grrr

    OK, I am irritated... I want a cell to highlight if two conditions are true. I keep getting a looping error. In cell A1 I want the following formula to work. =IF(AND(ISTEXT(A1),A28="Bath Day"),cellcolor=yellow,"") here is a copy of the area <table border="0" cellpadding="0" cellspacing="0"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top