Help with Excel percentages
Solved/Closed
        Related:         
- Help with Excel percentages
 - Excel mod apk for pc - Download - Spreadsheets
 - Kernel for excel repair - Download - Backup and recovery
 - Percentage formula in excel marksheet - Guide
 - Vat calculation excel - Guide
 - Menu déroulant excel - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Mar 11, 2010 at 06:31 PM
    Mar 11, 2010 at 06:31 PM
                        
                    From what I understood from your question
=IF(A5>B5, (B5-C5)/(A5-B5), "")
you can format this cell to be %age
or you can try this
=IF(A5>B5, 100 *(B5-C5)/(A5-B5), "")
            =IF(A5>B5, (B5-C5)/(A5-B5), "")
you can format this cell to be %age
or you can try this
=IF(A5>B5, 100 *(B5-C5)/(A5-B5), "")
        
    
    
    
    
Mar 15, 2010 at 01:07 PM
Came in Monday morning and u answered with correct formula. Have a great day