Posted to microsoft.public.excel.worksheet.functions
|
|
Need help with formula in excel
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
|