Thread: NESTED IF's too many
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
saturnin02 saturnin02 is offline
external usenet poster
  
Posts: 8
Default NESTED IF's too many
Index just works perfectly for my purpose.
Tx to everybody that contributes btw.
Sat

"Don Guillett" wrote in message
...
re-read.
Use INDEX as suggested

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"saturnin02" wrote in message
...
Hi,
I need to calculate If staments based on the formula below.
Unfortunately, there are too many nested IF statements.

How can I write this formula in a more intellignet way that will work?




=IF(B15=1,A15,IF(B15=2,A16,IF(B15=3,A17,IF(B15=4,A 18,IF(B15=5,A19,IF(B15=6,A


20,IF(B15=7,A21,if(B15=8,A22,IF(B15=9,A23,IF(B15=1 0,A24,IF(b15=11,A25,IF(B15
=12,A23,IF(B15=13,A26,IF(B15=14,A27)))))))

Tx,

Sat







Reply With QuoteReply With Quote