Afternoon Team,
Hope your well.
Simple ask (Famous last words)
I would like a formula to tell me if the received number is in 10% lower or higher threshold of the expected number
Example
Expected 100
Received 98
Outcome : Withing 10% Range
Expected 100
Received 78
Outcome : Outside 10% Range
Expected 100
Received 101
Outcome : Withing 10% Range
Expected Is in Column A
Received is in Column B
Hope this makes sense. Looking forward to your response
Last edited by masond3; 03-27-2019 at 04:17 AM.
Formula for C1
=IF(B1>=A1*0.9,"Within 10% Range","Outside 10% Range")
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.
put in C1
=IF(ABS(1-(B1/A1))<=0.1,"Within 10% Range","Outside 10% Range")
Apologizes all,
I have misaddressed my requirements to you.
Any number in the received column which is under 10% of the expected number the formula needs to say "Outside 10% Range"
Any number in the received column which is In or above 10% of the expected number the formula needs to say "Inside 10% Range"
Hoping you can help.
Try in D2:
Formula:
Please Login or Register to view this content.
pct.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks