if statements???

  1. D

    Need help copying several cells to another sheet, based on the condition of a check box

    I am trying to say if K3 (the checkbox) is true (checked), then copy Complaints!B3 through Complaints!E3 to Citations!B3 through Citations!E3. My other option is to change the checkbox to a Yes/No drop down, if that's any easier. Thanks.
  2. M

    Copying between sheets based on dropdown list selection?

    Hiya! I'm using Excel 2003 to keep track of grades in a college class that I teach. Each category of graded items has its own worksheet with all grade data for all students, and I have an Overview worksheet that calls up data from the other worksheets that tell me total items passed / points...
  3. I

    Date Range If Statement with 3 Possible Outcomes - PLEASE HELP!

    I am trying to write a formula that will test if a re-fi date is in an annual date range (eg. 01/01/xx-12/31/xx). I need it to return the remaining balance at different dates or "0" depending on the outcomes. IF Re-Fi Date is > Annual period = Balance at the end of that year IF Re-Fi Date is...
  4. V

    If Statement Help Please!!!!

    I haven't used 'IF' statements too much, and I'm uncertain that I should be using this function for my challenge, but I thought it was a good place to start. Here's my issue: I thought using an 'IF' statement would be what's needed to determine the following: Based on # of weeks If # of...

Watch MrExcel Video

This Week's Hot Topics

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
Top