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

Formula that will make a specific text into a number
Number to words in excel formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Position formula in excel - Office Software Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum

1 response

Answer 1 / 1

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

Similar discussions

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

Highlight cell if another cell contains specific text

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!