Thread: Can you get around the 7max IF function?
View Single Post
  #1   Report Post  
Seti Seti is offline
Junior Member
  
Posts: 14
Default Can you get around the 7max IF function?
Here is my current formula:

=IF(B41<29,"$.03",IF(B41<=34,"$.03",IF(B41<=39,"$. 06",IF(B41<=44,"$.09",IF(B41<=49,"$.15",IF(B41<=54 ,"$.26",IF(B41<=59,"$.42",IF(B41<=64,"$.56"))))))) )

The formula is actually 8 and it is allowing it, but anything after that it wont. I need to add 3 more...is there a way to do this. I tried a few suggestions in another thread but it wasnt working.

Thanks!
Reply With QuoteReply With Quote