Display value in a cell A7 which is refered to the value in A6
Closed
lokesh
-
Feb 9, 2015 at 09:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2015 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2015 at 11:49 AM
Hello,
I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the following conditions
1. A6>101.5%
2. 98.5<=A6=101.5%
3. A6>=98.5
I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the following conditions
1. A6>101.5%
2. 98.5<=A6=101.5%
3. A6>=98.5
Related:
- Display value in a cell A7 which is refered to the value in A6
- To display a text file in reverse order what command should be used - Guide
- Based on the value in cells b77 ✓ - Excel Forum
- A user tries to open a movie in windows media player but no image is displayed, and only audio plays. which software must be installed on the computer? ✓ - Video software Forum
- If cell contains date then return value ✓ - Office Software Forum
- The page cannot be displayed. (80710a06 - Internet & Social Networks Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 9, 2015 at 11:49 AM
Feb 9, 2015 at 11:49 AM
Hi Lokesh,
Try this:
=IF(A6>101.5%,YOURVALUE,IF(AND(A6>=98.5%,A6<=101.5%),YOURVALUE,IF(A6<=98.5%,YOURVALUE,"")))
Change YOURVALUE in your value.
Hopefully I interpreted your values correctly since 98.5<=A6 and A6>=98.5 is the same.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Try this:
=IF(A6>101.5%,YOURVALUE,IF(AND(A6>=98.5%,A6<=101.5%),YOURVALUE,IF(A6<=98.5%,YOURVALUE,"")))
Change YOURVALUE in your value.
Hopefully I interpreted your values correctly since 98.5<=A6 and A6>=98.5 is the same.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.