Caculations based on conditions
Closed
Peter
-
26 Jul 2009 à 07:41
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Jul 2009 à 06:12
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Jul 2009 à 06:12
Related:
- Caculations based on conditions
- Excel conditional formatting based on date - Guide
- Excel conditional formatting based on text ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Name Values - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
27 Jul 2009 à 06:12
27 Jul 2009 à 06:12
your data is in column A abd B,as given below. InC2 (NOT IN C!) copy paste this formula
=IF(B2>=5,ABS(A2-A1),"")
copy C2 down. see the values in col. C below
price volatality
51 4
55 5 4
61 4
57 6 4
52 6 5
49 8 3
58 5 9
=IF(B2>=5,ABS(A2-A1),"")
copy C2 down. see the values in col. C below
price volatality
51 4
55 5 4
61 4
57 6 4
52 6 5
49 8 3
58 5 9