Display value in a cell A7 which is refered to the value in A6
Closed
lokesh
-
9 Feb 2015 à 09:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 9 Feb 2015 à 11:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 9 Feb 2015 à 11:49
Related:
- Display value in a cell A7 which is refered to the value in A6
- How to delete a cell in word - Guide
- Internet explorer cannot display the webpage - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- The page cannot be displayed. (80710a06) - PS3 & PS4 Forum
- Excel multiple lines in one cell - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
9 Feb 2015 à 11:49
9 Feb 2015 à 11:49
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.
