is there ONE multiple IF function formula to inclue all of the below
if INS = nd and order is less than 5000 then 0% - -
if INS = nd and order is 5000 to 11999 then 70% -
if INS = nd and order is 12000+ then 8400/order
if INS has a value then INS/order
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!