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
Hello,
I need formula that will make a specific text into a number
example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, if A1 is R407C then B2 is 1774
Please help, this will make our ozone layer cleaner :))
I need formula that will make a specific text into a number
example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, if A1 is R407C then B2 is 1774
Please help, this will make our ozone layer cleaner :))
Related:
- Formula that will make a specific text into a number
- How to find specific words on a page - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Ms word number to words 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