| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HELP? ...a second condition in one formula
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 |
|
#2
|
|||
|
|||
|
ooohhh, sooo close...
=IF(F23+J28-F29<80,"The Total is less than 80 Hours. Is this Correct?", IF(F23+J28-F2980,-F24, F23+J28-F29)) Total = F23+J28-F29 If Total is less than 80 then Show Message otherwise, if Total is greater than 80 then show -F24 otherwise, (Total must equal 80 to get here) show Total. Q: If this formula is going into cell F30, rather than -F24, don't you mean F23+J28-F29 - F24? HTH, -- George Nicholson Remove 'Junk' from return address. "MichaelTM99" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Hey George... yes it is going into F30... I wanted to subtract F24 from F30.
Hopefully that will do what I need. I will try it George... and will get back... Thanks a ton for your response... if ya have further insight... please feel free to post it. THX! MTM "George Nicholson" wrote: ooohhh, sooo close... =IF(F23+J28-F29<80,"The Total is less than 80 Hours. Is this Correct?", IF(F23+J28-F2980,-F24, F23+J28-F29)) Total = F23+J28-F29 If Total is less than 80 then Show Message otherwise, if Total is greater than 80 then show -F24 otherwise, (Total must equal 80 to get here) show Total. Q: If this formula is going into cell F30, rather than -F24, don't you mean F23+J28-F29 - F24? HTH, -- George Nicholson Remove 'Junk' from return address. "MichaelTM99" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
Hey George... I tried that out. I don't get an error which is good... but my
F30 cell say -1, when my F23 says 81. I'd like it to be 80. Any idea's? Thanks again! "George Nicholson" wrote: ooohhh, sooo close... =IF(F23+J28-F29<80,"The Total is less than 80 Hours. Is this Correct?", IF(F23+J28-F2980,-F24, F23+J28-F29)) Total = F23+J28-F29 If Total is less than 80 then Show Message otherwise, if Total is greater than 80 then show -F24 otherwise, (Total must equal 80 to get here) show Total. Q: If this formula is going into cell F30, rather than -F24, don't you mean F23+J28-F29 - F24? HTH, -- George Nicholson Remove 'Junk' from return address. "MichaelTM99" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Add condition to formula | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Linear Mode
