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.
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...
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...
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...
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.