Hello,
I want to set up a conditional format rule for the following rule:
The bias calculated for each value is to be no greater than ±0.005 or ±5% of the known value (as an example the known value will be 0.030), whichever is greater.
How would I set up a conditional format rule(s) like that?
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi,
Assuming formula in Post #2 follows your logic requirements, no need for the IF:
=AND(ROUND(A1,4)>=ROUND(0.03*(1+0.05),4),A1<=0.3*(1-0.05))
Or:
=ABS(ROUND(A1,4))<=ROUND(0.03*1.05,4)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks