Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jasmine Grant   on Aug 26 In MS Office Category.

  
Question Answered By: Dot net Sachin   on Aug 26

Absolutely.
The "mod" function tells you the REMAINDER
after two numbers are divided.
In the case you've completed,
you take the column  number, say 15..
divide it by two.
It goes into 15 seven times, leaving (1) left over.
since 1 does not equal 0, then the
If statement: if(# mod 2 = 0) is false.
For every 18 columns/rows,
simply use if(Target.column mod 18 = 0) the
This would then be true for column 18, 36, 54, 72, etc.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Change every second column to a negative number Or get search suggestion and latest updates.


Tagged: