Excellent Frank. That seemed to work... I appreciate it!!
I don't sprechen Deutsches, aber ich möchte sagen danke Ihnen! (via a
Translator)
I'll keep trying to figure the rest out, although you may see me post again!
"Frank Kabel" wrote:
Hi
try:
=IF(F23+J28-F29<80,"The Total does not equal 80 Hours. Is this
Correct?",F23+J28-F29-IF(F23+J28-F2980,F24,0))
--
Regards
Frank Kabel
Frankfurt, Germany
"MichaelTM99" schrieb im
Newsbeitrag ...
With the help of a Community member, the following formula works....
=IF(F23+J28-F29<80,"The Total does not equal 80 Hours. Is this
Correct?",F23+J28-F29)
However... I need to add this (or something that will function
correctly)
to the same formula... IF(F23+J28-F2980,-F24)
I need the cell to subtract cell F24 if it is greater than 80.
I had this... but it doesn't work...
=IF(F23+J28-F29<80,"The Total does not equal 80 Hours. Is this
Correct?",F23+J28-F29),IF(F23+J28-F2980,-F24)
================================
What I am trying to accomplish is: F30 is the Total hours for 2
weeks. It
should be 80. If it is greater than 80, I need to subract the
difference,
which should already be present in the Comp Time cell (F24), which
should
bring the Total back to 80. If it is less than 80, it will give the
value
from the formula above that works.
Again thx for any help. I have been trying to get these to work on
my own
before turning to help... but it keeps giving me errors. :(
All is appreciated!
--
Michael T M
|