I'm trying to setup a time tracker for myself, and everything works, but essentially I'm trying to tell one cell that if my hours are over 40, then calculate how much over time I have, and conditionally format it. When I'm under 40 hours it shows the results of "#VALUE!", when I'd rather it show me the words, "No OT."
So, with this being said, I've moved that cell off the screen so I don't see the "#VALUE!" being shown, and I've setup another cell on the screen with the formula: (Notes: 1=Overtime; 0=No Overtime; $D$20=no value if no overtime is accumulated (aka #VALUE!), and the sum of overtime if it is accumulated) =IF(D10=1,Show the contents of cell $D$20,"No OT") and I write the formula like this, =IF(D10=1,=D20,"No OT").
I've put what my intentions are for my formula in green, and I've put my formula in dark blue font color.
I cannot get the value_if_true to equal another value from another cell though, using this method. So I'm guessing there's got to be another way to do this?
Any suggestions?
-Enigma[/img]
So, with this being said, I've moved that cell off the screen so I don't see the "#VALUE!" being shown, and I've setup another cell on the screen with the formula: (Notes: 1=Overtime; 0=No Overtime; $D$20=no value if no overtime is accumulated (aka #VALUE!), and the sum of overtime if it is accumulated) =IF(D10=1,Show the contents of cell $D$20,"No OT") and I write the formula like this, =IF(D10=1,=D20,"No OT").
I've put what my intentions are for my formula in green, and I've put my formula in dark blue font color.
I cannot get the value_if_true to equal another value from another cell though, using this method. So I'm guessing there's got to be another way to do this?
Any suggestions?
-Enigma[/img]