Site-searching question - .com.unity Forums

#14

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

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.

__________________
My mod page - wraparound maps, spell descriptions mod, starting locations utility

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Forum Rules

Forum Jump