formula for: if a1 is greater than 1 but less than 10 value is "a" and how to
nest it for 7 iterations

Can you explain what you mean by "nest it for 7 iterations"?

--
Rick (MVP - Excel)


"Ron E" <Ron wrote in message
...
formula for: if a1 is greater than 1 but less than 10 value is "a" and how
to
nest it for 7 iterations

this is what i need. i appreciate any help

if 0-1.0 value 0.05
if 1-1.0 value 0.1
if '10-40 value 1
if '40-100 value 5
if '100-400 value 10
if 400-1000 value 50
if 1000+ value 100

"Rick Rothstein" wrote:

Can you explain what you mean by "nest it for 7 iterations"?

--
Rick (MVP - Excel)


"Ron E" <Ron wrote in message
...
formula for: if a1 is greater than 1 but less than 10 value is "a" and how
to
nest it for 7 iterations

See if this formula does what you want...

=IF(A1<1,0.05,IF(A1<10,0.1,IF(A1<40,1,IF(A1<100,5, IF(A1<400,10,IF(A1<1000,50,100))))))

Note: You end points overlapped (for example, 40 appeared in two test
conditions), so you may want to change my < to <= if I guessed wrong as to
which range you actually wanted them in.

--
Rick (MVP - Excel)


"Ron E" wrote in message
...
this is what i need. i appreciate any help

if 0-1.0 value 0.05
if 1-1.0 value 0.1
if '10-40 value 1
if '40-100 value 5
if '100-400 value 10
if 400-1000 value 50
if 1000+ value 100

"Rick Rothstein" wrote:

Can you explain what you mean by "nest it for 7 iterations"?

--
Rick (MVP - Excel)


"Ron E" <Ron wrote in message
...
formula for: if a1 is greater than 1 but less than 10 value is "a" and
how
to
nest it for 7 iterations

Another one:

=IF(COUNT(A1),LOOKUP(A1,{0,1,10,40,100,400,1000},{ 0.05,0.1,1,5,10,50,100}),"")

--
Biff
Microsoft Excel MVP


"Ron E" wrote in message
...
this is what i need. i appreciate any help

if 0-1.0 value 0.05
if 1-1.0 value 0.1
if '10-40 value 1
if '40-100 value 5
if '100-400 value 10
if 400-1000 value 50
if 1000+ value 100

"Rick Rothstein" wrote:

Can you explain what you mean by "nest it for 7 iterations"?

--
Rick (MVP - Excel)


"Ron E" <Ron wrote in message
...
formula for: if a1 is greater than 1 but less than 10 value is "a" and
how
to
nest it for 7 iterations