Resolving #VALUE! Error in weight chart

[jazzkid]

I have a weight chart used monthly to identify if a patient is underweight or not. On occasions patients either refuse to have their weight monitored or they are absent at the time the weights are recorded. Due to the formula used in the chart, anything other than a number results in a #Value in the cell where it identifies if the patient is underweight.
What do i need to do to alter the formula in cells in columns D and E etc to prevent the #Value

Thanks for any assistance

Sue

 

[Pofski]

Hi,

If you would like the cells to just remain blank, in stead of giving the #value! error, you could just put existing formulas in an iferror.
An example would be the D5 formula: =IFERROR(IF($B5>0,C5/($B5*$B5),""),"")

Hope this is what you are looking for.

 

[jazzkid]

Thanks for the suggestion. That created another issue with the formula in E5. I have uploaded the file again with the result of the formula you suggested =IFERROR(IF($B5>0,C5/($B5*$B5),""),"")
If the result at row D is blank, the result at row E needs to be as well. I tried to rectify it using the IFERROR, however, didn't get the formula correct - so am handing it back here for an expert. Thanks

 

[Hui]

E3: =IFERROR(IF(C3>0,IF(D3<18.5,2,IF(D3<20,1,IF(D3<30,0,IF(D3="","","Obese"))))," "),"")
Copy down


or it could be shortened to: =IFERROR(IF(D3<18.5,2,IF(D3<20,1,IF(D3<30,0,IF(D3="","","Obese")))),"")

Note the use of the Iferror() function to capture all errors

 

[jazzkid]

Thanks - that does work