Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying multiples of 10 | Excel Discussion (Misc queries) | |||
Displaying multiples of 10 | Excel Discussion (Misc queries) | |||
Displaying multiples of 10 | Excel Discussion (Misc queries) | |||
summing multiples lines in a vlookup function | Excel Worksheet Functions | |||
trigger help | Excel Worksheet Functions |