using switch with formulas in the target cells

[andrewb90]

Hello all,

When I use SWITCH, and the values are formulas I don't get any result, when the values are just values i do. is there an alternative?

Here's a shortened example:

=SWITCH(D15,KDS!L9,KDS!N9,KDS!M10,KDS!N10,KDS!M11,KDS!N11,"-")

KDS!L9:

=M10-TIME(0,1,0)

the value is 3:33
if I type that in directly, it works. If I leave the formula in that and the adjacent cells, I don't get anything other than "-" as my result.

 

[dUBBINS]

I am not a pro, and I have never used SWITCH(). But could you use .VALUE in your code to pull the value of the Cell, rather than the formula?

...range("d15").value,....

 

[andrewb90]

that kept throwing invalid formula errors.

 

[Norie]

What's the value/formula in D15?

 

[andrewb90]

The value is 3:33

 

[Aladin Akyurek]

What do you have in D15? Even better: What is the formula to do?