Hopefully someone can help me with this. I'm not sure if I need to use
an IF statement to acheive the desired results.
Column I has numeric values from 0 - 30 in it. In Column J I want to be
able to show some goupings for instance 1 - 5, 6 - 11, 12 - 17 etc. This
would be determined by the value in Column D.
It would look like the below example:
_Column_I_ _Column_J_
10 6 - 11 Days Out
5 1 - 5 Days Out
3 1 - 5 Days Out
16 12 - 17 Days Out
I was using the folowing IF statement which works from 1 - 5 and 6 -
11, but now I am stuck. =IF(I5<6,"1-5 Days Out",IF(I55,"6 - 11 Days
Out"))
Thanks in advance for your help!:)
--
jgp_2
------------------------------------------------------------------------
jgp_2's Profile:
http://www.excelforum.com/member.php...o&userid=27624
View this thread:
http://www.excelforum.com/showthread...hreadid=487452