On 8/28/2011 11:20 PM, Randy Barrett wrote:
I'm trying to make a formula where lets say cell A1 has a number
without a formula. In cell H1 I want to make a formula that follows
these guidlines.
A1 H1
0-99 0
100-199 1
200-299 2
300-399 3
400-499 4
500-599
On 8/28/2011 11:20 PM, Randy Barrett wrote:
I'm trying to make a formula where lets say cell A1 has a number
without a formula. In cell H1 I want to make a formula that follows
these guidlines.
A1 H1
0-99 0
100-199 1
200-299 2
300-399 3
400-499 4
500-599 5
2011/8/29 Randy Barrett :
> I'm trying to make a formula where lets say cell A1 has a number without a
> formula. In cell H1 I want to make a formula that follows these guidlines.
> A1 H1
> 0-99 0
> 100-199 1
> 200-299 2
> 300-399 3
> 400-499 4
> 500-599 5
> 6
On Tue, Aug 30, 2011 at 7:54 AM, Martin du Saire wrote:
> my bad. I thought you meant that you wanted a result of zero for any
> integer 0 through 99...
>
>
Well to be honest you could be right. I took the example provided literally.
Interesting to see how the OP responds.
/paul
--
my bad. I thought you meant that you wanted a result of zero for any integer
0 through 99...
On Mon, Aug 29, 2011 at 2:50 PM, Paul wrote:
> On Sun, Aug 28, 2011 at 11:20 PM, Randy Barrett <
> iatepaintch...@comcast.net> wrote:
> I'm trying to make a formula where lets say cell A1 has a number wi
On Sun, Aug 28, 2011 at 11:20 PM, Randy Barrett
wrote:
I'm trying to make a formula where lets say cell A1 has a number without a
formula. In cell H1 I want to make a formula that follows these guidlines.
A1 H1
0-99 0
100-199 1
200-299 2
300-399 3
400-499 4
500-59
int(a1/100)
On Sun, Aug 28, 2011 at 11:20 PM, Randy Barrett
wrote:
> I'm trying to make a formula where lets say cell A1 has a number without a
> formula. In cell H1 I want to make a formula that follows these guidlines.
> A1 H1
> 0-99 0
> 100-199 1
> 200-299 2
> 300-39