I need more than 8 IF functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please

Thanks
 
Many solutions, tell us the data and the requirement in detail.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You never need more than 7 nested IFs. There's always a better solution,
typically Vlookup or Index. Post your requirements. You'll get lots of
suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In new Office 2007 EXCEL, can more the 8 IF statements be used? 1
How to create a bubble chart with more than 2 variables 0
How to turn a number range into a date 2
CHOOSE function - more than 29 items 1
Security at Record Level 2
MOre than 8 argurement 5
HELP. I need an "IF" formula with a lot of information 6
Copy Excel functions formula and auto refresh refresh 3

Back
Top