# If less than 100% then cells equal

#### Smurfit-Stone

##### Active Member
I need a formula to move data from one sheet tab to another. I have a spreadsheet with weekend as tabs. I need to move data forward to the next week (tab) if its (column F) is less than 100%, then I need to carry the info to the next sheet. Something like If (Oct 28'!D2:D7 <100, then Nov 4'! D2:D7=Oct 28 (D2:D7) I know this is wrong....but something like this. Thanks!

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### tactps

##### Well-known Member
In 'Nov 4'!D2
=if(sum('Oct 28'!d2:D7)<100,'Oct'!D2,0)
and copy down.

Replies
0
Views
325
Replies
2
Views
163
Replies
1
Views
461
Replies
8
Views
578
Replies
4
Views
136

1,195,716
Messages
6,011,274
Members
441,598
Latest member
chrispaulpearce

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

### Which adblocker are you using?

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

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