I am trying us an IF statement to populate text in a cell, based off value in previous cell.

Smith5402

=IF(RPN@row > "400", "HIGH", IF(RPN@row < "150", "LOW", "MEDIUM"))

Based off the values, the text does not always populate correctly. Example - a value of 5 will come back as "HIGH". A value of 25 shows "MEDIUM". A value of 125 shows "LOW".

Jeremy_D

I think it might be becuase you've put the numbers in speech marks. The speech marks tell it to look for the exact wording. When using numbers you don't need them, so if you remove them on the 400 and 150 does that work?

Jeremy_D

I think it might be becuase you've put the numbers in speech marks. The speech marks tell it to look for the exact wording. When using numbers you don't need them, so if you remove them on the 400 and 150 does that work?

Smith5402

Jeremy, thank you. Yes, it did work.