Formula that will make a specific text into a number

Closed
Hello, I need formula that will make a specific text into a n - 26 Aug 2016 à 03:32
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 26 Aug 2016 à 07:31
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 :))

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
26 Aug 2016 à 07:31
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