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 Contributor Last seen December 27, 2022 - Feb 9, 2015 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Feb 9, 2015 at 11:49 AM
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 page cannot be displayed. (80710a06) - PS3 & PS4 Forum
- Based on the values in cells b77:b81, which function can automatically return the value in cell c77 ✓ - Excel Forum
- 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
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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.
