View Single Post
  #14  
Old September 28th, 2007, 02:25 AM

DireAussie DireAussie is offline
Corporal
 
Join Date: Oct 2006
Posts: 67
Thanks: 0
Thanked 0 Times in 0 Posts
DireAussie is on a distinguished road
Default Re: Site-searching question

It requires a slight change to the formula, basically it needs an extra IF condition for the >= test

fixed formula for row BF2:
Code:
=IF(IF(MOD($E2+32768,SiteMasks!$A$3)>=SiteMasks!$A  $2,1,0)=1,"Yes","")



The formula is the same through to row BP2 but you have to replace the numbers from $A$3 and $A$2 with the numbers from the old formula. Then you can just fill down the columns.
Reply With Quote