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.