I am having trouble trying to format a column that displays a text depending upon whether the column next to it is greater than, less than, or in between a certain value. More particularly, something like this,
#<2 it should display "Short"
#>2.5 it should display "Long"
2<#<2.5 it should display "Intermediate"
There are about 15 rows of #'s so the IF/AND statement should be the same for each row, just able to drag through the column. Any help would be greatly appreciated. Thank you
#<2 it should display "Short"
#>2.5 it should display "Long"
2<#<2.5 it should display "Intermediate"
There are about 15 rows of #'s so the IF/AND statement should be the same for each row, just able to drag through the column. Any help would be greatly appreciated. Thank you
