Caculations based on conditions
Closed
Peter
-
Jul 26, 2009 at 07:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 27, 2009 at 06:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 27, 2009 at 06:12 AM
Related:
- Caculations based on conditions
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Want to close my account - Facebook Forum
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 27, 2009 at 06:12 AM
Jul 27, 2009 at 06:12 AM
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