R
Ron E
formula for: if a1 is greater than 1 but less than 10 value is "a" and how to
nest it for 7 iterations
nest it for 7 iterations
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
Can you explain what you mean by "nest it for 7 iterations"?
R
Rick Rothstein
Can you explain what you mean by "nest it for 7 iterations"?
R
Ron E
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
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
R
Ron E
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
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
R
Rick Rothstein
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.
=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.
R
Rick Rothstein
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.
=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.
T
T. Valko
Another one:
=IF(COUNT(A1),LOOKUP(A1,{0,1,10,40,100,400,1000},{0.05,0.1,1,5,10,50,100}),"")
=IF(COUNT(A1),LOOKUP(A1,{0,1,10,40,100,400,1000},{0.05,0.1,1,5,10,50,100}),"")
T
T. Valko
Another one:
=IF(COUNT(A1),LOOKUP(A1,{0,1,10,40,100,400,1000},{0.05,0.1,1,5,10,50,100}),"")
=IF(COUNT(A1),LOOKUP(A1,{0,1,10,40,100,400,1000},{0.05,0.1,1,5,10,50,100}),"")