Thread: Can I create a formula with more than 8 IF statements?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul P
 
Posts: n/a
Default Can I create a formula with more than 8 IF statements?
I have created the following formula:

=IF(Q12=94,"5.7",IF(Q12=86,"5.3",IF(Q12=78,"5.0 ",IF(Q12=69,"4.7",IF(Q12=59,"4.3",IF(Q12=49,"4. 0",IF(Q12=41,"3.7",IF(Q12=21,"3.0",2))))))))

but I really want to add one or two more IF statements. It does not seem to
be possible.

Any suggestions
Reply With QuoteReply With Quote