Apple / Powermac8

I am using Excel 2004 for MAC on a Mac OS X Version 10.4.11 system. iMac G5 PowerMac8, 1 I have multiple "if" functions for one cell along with a range....here is what I'm trying to do:

If b7/b6<.85, then b7*0, however

if b7/b6>.85 but <=.89, then b7*.5, however

if b7/b6 >=.9 but <=.94, then b7*1, however

if b7/b6 >=.95 but <=.99, then b7*2and so on.....how do I do this with all the greater than and equal to and multiple if's?

=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.

Ask Your Question

Weekly Poll

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History