How do I enter mutiple if formulas?

February 14, 2011 at 12:21:32
Specs: Macintosh
I have multiple if functions for once 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*2

and so on.....how do I do this with all the greater than and equal to and mutiple if's?


See More: How do I enter mutiple if formulas?

Report •

#1
February 14, 2011 at 13:00:36
You seem to have forgotten you System Specs, Macintosh as a line of Apple Computers for 30 years so many models and O/S. Also you never mentioned the software you are refering to. Last but not least my crystal ball has bust !

Report •
Related Solutions


Ask Question