View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cincinnatikid123 cincinnatikid123 is offline
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!!!