I inherited a spread sheet that uses a technique I've never seen before to decide whether a time in a cell falls between two others.
=IF(PRODUCT({"08:00:00","20:00:00"}-D6)<0,"NO CHARGE",72.31)
I kind of like this one over the alternative of IFs, ANDs etc.
However part of what I am doing is making the models more flexible so that all the parameters and charges are kept in a series of tables and updated there so the model can be used across different contracts just by changing those tables, when I try and change the two times hard coded into the formula above to links to cells containing those values it won't let me enter it, giving me an error and highlighting the references to the cells containing the times as the issue.
While I could just change the formula for each contract and make sure it's dragged down, I'd rather retain the use of the table based approach.
Is there anyway to do that?
=IF(PRODUCT({"08:00:00","20:00:00"}-D6)<0,"NO CHARGE",72.31)
I kind of like this one over the alternative of IFs, ANDs etc.
However part of what I am doing is making the models more flexible so that all the parameters and charges are kept in a series of tables and updated there so the model can be used across different contracts just by changing those tables, when I try and change the two times hard coded into the formula above to links to cells containing those values it won't let me enter it, giving me an error and highlighting the references to the cells containing the times as the issue.
While I could just change the formula for each contract and make sure it's dragged down, I'd rather retain the use of the table based approach.
Is there anyway to do that?