IF function - missing 1 IF and more

[Wanna Learn]

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

 

[Pecoflyer]

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) i
the
person has not submitted the report I do not want the answer to b
-37.50 but
"" (blank) if the person submitted the report and did not work overtim
or
worked less than 37.5 the answer should also be blank, if the perso
did
work overtime then the hours less 37.50 Example hours worke
45.50 so
overtime would be 8 hours . thanks

Does this help ?

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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[Wanna Learn]

Thanks This works , except if the person did not submit the report I get
#NA. If the person did not submit the report I want it to be blank so I
added the following to the formula
=IF(ISERROR(VLOOKUP(B3,TB!B3:J125,9,FALSE)),"
",IF(VLOOKUP($B3,TB!$B$10:$J$125,9,FALSE)<=37.5,"
",VLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week)) I still bet #NA thanks in
advance

 

[Pecoflyer]

Thanks This works , except if the person did not submit the report
get
#NA. If the person did not submit the report I want it to be blank s
I
added the following to the formula
=IF(ISERROR(VLOOKUP(B3,TB!B3:J125,9,FALSE)),"
",IF(VLOOKUP($B3,TB!$B$10:$J$125,9,FALSE)<=37.5,"
",VLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week)) I still bet #NA thank
in
advance



Cage Forums' (http://www.thecodecage.com/forumz/showthread.php?t=64887)

A little faster would be
=IF(or(countif(B3,TB!B3:B125)=0,VLOOKUP($B3,TB!$B$10:$J$125,9,FALSE)<=37
5),"",VLOOKUP($B3,TB!$B$3:$J$125,9,FALSE)-Week)

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste