Wanna Learn;232425 Wrote:
Hello this is my formula

=IF(VLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week=-37.5,"",IFVLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week)
Week = named ranged for 37.5 (normal working hours in a week) if
the
person has not submitted the report I do not want the answer to be
-37.50 but
"" (blank) if the person submitted the report and did not work overtime
or
worked less than 37.5 the answer should also be blank, if the person
did
work overtime then the hours less 37.50 Example hours worked
45.50 so
overtime would be 8 hours . thanks

Does this help ?

=IF(VLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)<=37.5,"",V LOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64887