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
- Excel conditional formatting based on date - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - 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
