By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

IIF Statement - If field is greater than other field by =/-percentage

P: 1
Hello everyone,

I have the current formula
Expand|Select|Wrap|Line Numbers
  1. CompPassFail: IIf([specifiedComp]>[PCcomp],"Fail","Pass")
This works O.K, but I am being told that it should pass or fail if is within -/+3percent. Both field are percentage fields, where[specifiedComp]is the main number that [PCcomp] has to more or less align to.
Apr 4 '17 #1

✓ answered by NeoPa

IWestwell:
This works O.K, but I am being told that it should pass or fail if is within -/+3percent.
That doesn't actually make sense. I assume you mean that it will be a pass if it's within three percentage points of the pass threshold ([specifiedComp]).

If so then change it to :
Expand|Select|Wrap|Line Numbers
  1. CompPassFail: IIf([specifiedComp]-3>[PCcomp],'Fail','Pass')

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,409
IWestwell:
This works O.K, but I am being told that it should pass or fail if is within -/+3percent.
That doesn't actually make sense. I assume you mean that it will be a pass if it's within three percentage points of the pass threshold ([specifiedComp]).

If so then change it to :
Expand|Select|Wrap|Line Numbers
  1. CompPassFail: IIf([specifiedComp]-3>[PCcomp],'Fail','Pass')
Apr 5 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.