Using IF function for multiples of a trigger

  • Thread starter Thread starter cincinnatikid123
  • Start date Start date
C

cincinnatikid123

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!!!
 
This formula will work for multiples of 200. Modify as necessary...
=MOD(A1, 200) <> 0
 
Thanks Jim, that's helpful.

Is there also a way I can get it to trigger at not just the exact value, but
when it surpasses the value? For example, I have this column of data:

187
196
214
223

Can I get it to trigger in the cell containing the 214, as this is the first
cell in which it has gone over the "trigger" multiple of 200?
 
Back
Top