Thread: IF Formula
View Single Post
  #5   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Pepito Grillo wrote:


As you can see, I am just giving more values. Is there a limit for IF to be
used ?



Yes, there is a limit to the depth of an IF statement. For your problem
I wouldn't bother with an IF anyhow. Try the following:

[ ] = CHAR(CODE("A")-1+C5)

Good luck....

Bill