View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_45_] JBeaucaire[_45_] is offline
external usenet poster
 
Posts: 1
Default Nested If functions and Formulas


Just me, but logically wouldn't you want B7 to be 0 for anything in B6
from zero to 7.5? Overtime doesn't kick in until after 7.5, right?

=IF(B6<=7.5,0,B6-7.5)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46792