Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My formula isn't working... :(
=IF((F23+J28)-F29)<80,"The Total does not equal 80 Hours. Is this Correct?",(F23+J28)-F29)) What am I missing? Or have I added something that shouldn't be there? I am adding to cells, and then subtracting one. I want the Total cell to equal what it is, but if it's not equal to 80, then to display the message from above. My syntax has to be bad... Any help is appreciated! THANK YOU!!!!! -- Michael T M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula help | Charts and Charting in Excel | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
hyperlink formula | Excel Discussion (Misc queries) |