View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ack ack is offline
external usenet poster
 
Posts: 1
Default if statement help

I have a formula that won't let me enter in any more if statements. Can you
help
This is what I have:

=IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,""))))

I have 8 of these if statements in the one cell and it won't let me put in
any more. Is there a different formula that I can use or modify this one?

Thanks!!