In excel, how can i change ALL values above a certain amount to a word?

Planning to change most values <1300 within my exceed document to somewhat of a certain phrase.According for this sheet patient given, that is entirely possible..help

You may use if terms.Somewhere towards the right of each of the cells you’ve filled within, put this in any cell:=IF(A1 < 1300, "The word you would like in saying marks", A1).Then check out that mobile and lug it down in order to the right far enough making sure that it encompasses each of the cells that truly have belongings.This will make a different large prevent of cells that can replace your whole old solar cells.

The first thing I didn’t remember – I am assuming you’ll have some empty cells inside your sheet, so you’ll have to modiy your current if statement making sure that those never get changed into a person’s word.Here’s the revolutionary if report:
IF(A1 < 1300, IF(A1 = "", A1, "The word"), A1)

One more little change:I screened it now so I recognize it operates.
IF(A1 < 1300, IF(A1 = "", "", "The word"), A1).

Leave a Reply