Formula that will make a specific text into a number
Closed
                                    
                        Hello,    I need formula that will make a specific text into a n                    
                                    -
                            Aug 26, 2016 at 03:32 AM
                        
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 26, 2016 at 07:31 AM
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 26, 2016 at 07:31 AM
        Related:         
- Formula that will make a specific text into a number
 - How to search for a specific word on a webpage - Guide
 - How do i find a specific video on youtube - Guide
 - Number to words in excel formula - Guide
 - Logitech formula vibration feedback wheel driver - Download - Drivers
 - Credit summation formula - Guide
 
1 response
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Aug 26, 2016 at 07:31 AM
    Aug 26, 2016 at 07:31 AM
                        
                    Dear User, Good morning. 
Try to use it:
B2 --> =IF(A1="R134a";1430;IF(A1="R404A";3922;IF(A1="R407C";1774;"")))
 
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
            Try to use it:
B2 --> =IF(A1="R134a";1430;IF(A1="R404A";3922;IF(A1="R407C";1774;"")))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão