Forum Discussion
Solved
Calculate time data into groups
I have a spreadsheet with data in column J for time shown as 05 for 5 min and 60 for 60 minutes. I want to show the data as: 05 or less "Less than 5" 5-10 "5 to 10" im using IF Statement buts not...
hi littlepatos
it seems your I column is text instead of number, try the following:
=IF(AND(VALUE($I2)>=0,VALUE($I2)<=5),"Leas than 5", IF(AND(VALUE($I2)>5, VALUE($I2)<=10),"5 to 10",""))
p.s. consider @some to continue a discussion.
hi littlepatos
it seems your I column is text instead of number, try the following:
=IF(AND(VALUE($I2)>=0,VALUE($I2)<=5),"Leas than 5", IF(AND(VALUE($I2)>5, VALUE($I2)<=10),"5 to 10",""))
p.s. consider @some to continue a discussion.