LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Using IF function for multiples of a trigger

I am using the =IF function in Excel 2003 to alert when a value has been
triggered. I know how to use it so that it triggers when a value is greater
than, equal to, less than, etc. What I want to do is set it so that it
displays "False" or triggers in some other way when it hits a multiple of a
number.

For example, if I set the trigger as 200, I would like it to trigger at 200,
400, 600, 800, and so on. For 300, trigger at 300, 600, 900, etc., and
display "True" at the other points.

If anyone can offer some advice I would greatly appreciate it, or if there
is another way to do this that does not require the IF function I am ok with
that too.

Thanks!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying multiples of 10 WavMaster Excel Discussion (Misc queries) 5 February 7th 09 08:08 AM
Displaying multiples of 10 Sheeloo[_3_] Excel Discussion (Misc queries) 0 February 7th 09 04:35 AM
Displaying multiples of 10 Sheeloo[_3_] Excel Discussion (Misc queries) 0 February 7th 09 04:35 AM
summing multiples lines in a vlookup function Rob T. Excel Worksheet Functions 5 December 16th 08 04:09 AM
trigger help climax Excel Worksheet Functions 1 February 2nd 06 04:39 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"