=18.5,H7<24.9,I7...Before I ask any further questions, just to let you know this is the first time I have try to do anything like this in Excel, so am quite new to it..." Everytime is a good time to start learning something new. "...please forgive my ignorance I am not sure what VLOOKUP is and how it works. I have had a look on line but am still unsure..." Don�t worry about it. We will help you understand VLOOKUP function in an easy and complete way. As you have a spreadsheet with a lot of things there,to easier it, please, save your spreadsheet example with no sensitive data but with enough data to understand well what you desire at, Upload - Speedy Share - upload your files here, putting link here for download. I believe we can help you to build a trustable spreadsheet. .">
  • Hot Topics

Excel "it uses more levels of nesting than are allowed in the current file format"

I am trying to design a Body Composition Measurement table which works out a persons risk rating by combining Body Mass Index (BMI) and waist circumference (WC). I have been using an 'IF' formula (Excel 07, Win8) which was working well until I got the following message: "it uses more levels of nesting than are allowed in the current file format" To make it more complicated I need the two formulas below as one and for the cell to know the difference between Male 'M' and Female 'F' when entered into the gender cell (cell 'E') to give the correct result depending on sex. In the formula below H7 is BMI, I7 is the WC. Females and males work with the same BMI range but the WC is different as you will notes when looking a both formulas. Does anyone know how to make this work? Your help is greatly appreciated Matt Males =IF(AND(H7<=18.5,I7<=102),"Increased Risk", IF(AND(H7>=18.5,H7<24.9,I7...Before I ask any further questions, just to let you know this is the first time I have try to do anything like this in Excel, so am quite new to it..." Everytime is a good time to start learning something new. "...please forgive my ignorance I am not sure what VLOOKUP is and how it works. I have had a look on line but am still unsure..." Don�t worry about it. We will help you understand VLOOKUP function in an easy and complete way. As you have a spreadsheet with a lot of things there,to easier it, please, save your spreadsheet example with no sensitive data but with enough data to understand well what you desire at, Upload - Speedy Share - upload your files here, putting link here for download. I believe we can help you to build a trustable spreadsheet.

This question generated 44 answers. To proceed to the answers, click here.

This thread is current as of October 15, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy