Formula that will make a specific text into a number

[Closed]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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