on 07-29-2015 3:51 AM
Hi, anyone know how to do this: Alert KF: If KF1 / KF2 is a whole number (no numbers after decimals), then alert is 1 otherwise 0.
Thanks!
Hi,
Try this:
Alert KF = IF(((KF1/KF2)%1)=0,1,0)
Regards,
Kent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response! I havent seen the % sign as a valid operator in the available documentation for the possible calculations. What does % do and did you see this in one of the demo models or somewhere else? Does you proposal work in following scenarios:
KF2 is 5x KF1 e.g KF1 = 100, KF2 = 500
KF1 is 5x KF12 e.g KF1 = 500, KF2 = 100
Hi John,
Yes, this is in the documentation (section 8.9 Commonly Used Functions). It is the modulus operator.
You can test your logic in Excel with the MOD() function. They both give you the remainer of a result. So by dividing your KF by a value of 1, the % operator will just provide you with the remainer for that KF.
Regards
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.