View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DMB
 
Posts: n/a
Default The 7 nested If() function Limitation. Is there anouther way?

I need to be able to check for more alternatives. These are Structural
Hardware and my if statement chooses a holdown type base on a cell and the
capacity of the hardware.

=IF(C69=0, 0,
IF(C69<500, "N.R.",
IF( C69<3610, "PHD2",
IF( C69<4685, "PHD5",
IF( C69<5860, "PHD6",
IF( C69<8325, "HDQ8",
IF( C69<9615, "HHDQ11",
IF( C69<12350,
"HHDQ14", "VERIFY"))))))))

I need to do more checks after the 12350 lb capacity. There could be a dozen
or more needed.

Thankyou DMB