hooper12345
New Member
- Joined
- May 12, 2015
- Messages
- 36
I have a separate that contains every week for the current year. I am running reports and graph from the data entered into those weeks. I noticed a patterned for the formulas I was entering and wanted to make my task simpler seeing how I have 20+ sheets to do the exact same thing. Basically I need to pull the info entered in to every 5th cell on two separate occasions in one formula. Below is the formula I'm using.
=IF('SpreadSheetName!D5="","Blank", IF('SpreadSheetName'!F5>='SpreadSheetName'!$D$6,"Green","Red"))
The D5 cell will be every 5th (D10, D15, D20...) and the F5 cell will be every 5th (F10, F15, F20..)
I have tried =IF('SpreadSheetName!(ROW(D:D)-,5)="","Blank", IF('SpreadSheetName'!(ROW(F:F)-,5>='SpreadSheetName'!$D$6,"Green","Red")) and was unsuccessful.
Any help is greatly appreciated!
=IF('SpreadSheetName!D5="","Blank", IF('SpreadSheetName'!F5>='SpreadSheetName'!$D$6,"Green","Red"))
The D5 cell will be every 5th (D10, D15, D20...) and the F5 cell will be every 5th (F10, F15, F20..)
I have tried =IF('SpreadSheetName!(ROW(D:D)-,5)="","Blank", IF('SpreadSheetName'!(ROW(F:F)-,5>='SpreadSheetName'!$D$6,"Green","Red")) and was unsuccessful.
Any help is greatly appreciated!
