CODEWITHSUNDEEP
excelgoogle-sheetsspreadsheet
Prajith SN
Prajith SN

Reputation: 77

How to replace text in a google spreadsheet cell with another text using if condition

I want to know how to change value / text in a spreadsheet cell with another I tried this "=IF(C15="100%",high,Medium)" - but no luck.

Note: the cell should be editable...

Upvotes: 1

Views: 9141

Answers (3)

Lucas Sant'Anna
Lucas Sant'Anna

Reputation: 1

I stumbled upon this very old unsolved thread while looking for something else. I believe i have the solution, so I'm posting it with a 6 years delay.

In Format -> Numbers -> More Number Formats -> Custom Number Formats, type in:

[=1]"High";[>0]"Medium";"Low"

This way, when you put in the value 50% inside the cell, the value is shown as "Medium".

Hopefully this helps someone!

Upvotes: 0

riddler
riddler

Reputation: 467

Use Number → Format → Percent on the toolbar to format the values as percentages. It's better to use a range to map them. 

=IF(C15>0.5, "High", IF(C15>=0.2, "Medium", "Low"))

Explanation: If cell value is greater than 50% it maps as High, else if it's greater than equal to 20% it maps as Medium, else it maps as Low.

You need the quotes as it's a word as opposed to a number or a reference to a cell.

Upvotes: 2

Netloh
Netloh

Reputation: 4378

When you write 100% or 99% in a cell it automatically formats it as a share, i.e. 1 and 0.99, respectively.

Try the formula =if(C15=1,"High",IF(C15=0,"Low","Medium"))

Upvotes: 0

Related Questions