Hi, all - I have been banging my head on the desk over this one...it's gotta be so simple, right? Have searched online, and on Mr. Excel, but still can't get this right.
I need a formula in cell H2 that says "IF cell H2 is greater than 0 but less than 30 then show 0-30, H2 is greater than 31 but less than 60 then show 31-60, H2 is greater than 61 but less than 90 then show 61-90, H2 is greater than 91 but less than 120 then show 91-120, H2 is greater than 121 but less than 150 then show 121-150, H2 is greater than 151 but less than 180 then show 151-180
Thanks in advance!
I need a formula in cell H2 that says "IF cell H2 is greater than 0 but less than 30 then show 0-30, H2 is greater than 31 but less than 60 then show 31-60, H2 is greater than 61 but less than 90 then show 61-90, H2 is greater than 91 but less than 120 then show 91-120, H2 is greater than 121 but less than 150 then show 121-150, H2 is greater than 151 but less than 180 then show 151-180
Thanks in advance!