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
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 :))
Related:

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
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
0