|=IF(B7/B6 < .85, 0, IF(AND(B7/B6 > .85, B7/B6 <= .9), B7*.5, IF(AND(etc.|
2 things to keep in mind:
1 - I don't see a desired result for B7/B6 = .85
2 - If 2004 on a Mac is similar to 2003 on a Windows machine, then you are going to be limited to 7 Nested IF's.
Once you get above 7, you'll need to try a different technique, such as VLOOKUP.
Even before you get to 7 Nested IF's, a VLOOKUP table might be a better solution. With a VLOOKUP table you could change your criteria (.85, .9, etc) by changing the table, instead of editing the formula. This is especially useful if you will replicating the long Nested IF formula across multiple cells.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.