Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Reference in formula increment
I was wondering how to calculate NETWORLDAYS based on
certain conditions. For my current situation I have 2 checks that see if either an N/A or a ""(blank) should be displayed, if neither of those conditions is true then to fill the second argument of the nested If function I have the NETWORKDAYS function. Ex Formula : =IF('sheet1'! E53="N/A","N/A",IF('sheet1'!E53="","",NETWORKDAYS('sheet1'! D53,'sheet1'!E53,'sheet1'!D53))). What I want is a way to check another column of data to see if I even want to evaluate any of these cases. If I do not want to evaluate any of these cases based on the other columns data I either want there to be absolutely nothing in the cell including the formula or What I would really like is for the formula to increment its references to (sheet1'!E54) (replacing the sheet1'!E53's) for example and check the values if the previous case is thrown out. I would like this to happen in the cell that is going to have the formula. If this is not possible using excel formulas could anyone point me in the right direction to a VBA solution for excel. I'm assuming for the algorithm there has to be an end case like and empty cell that would stop the increment etc.....Thank you for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - How to increment cell reference by one row | Excel Worksheet Functions | |||
How to increment a cell reference in a row | Excel Discussion (Misc queries) | |||
increment cell reference in a formula | Excel Worksheet Functions | |||
Need formula to increment cell reference every 8th row | Excel Discussion (Misc queries) | |||
Increment cell reference | Excel Discussion (Misc queries) |