Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-11-2018, 08:44 AM
Marcia's Avatar
Marcia Marcia is offline A formula to return value based on the sex, age and BMI of a person Windows 7 32bit A formula to return value based on the sex, age and BMI of a person Office 2007
Expert
A formula to return value based on the sex, age and BMI of a person
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Debaser. It took me sometime to reply because when I copied the formula and edited it to fit into my actual data, a lot of N/A came out, caused by children below 72 months of age. I did not notice that there is a separate growth table for infants to toddlers. I will try adding another IFs in the formula that you gave. I hope I'll get it right.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to return a value of 1,2,3 or based on a set criteria Highlander01 Excel 7 06-02-2017 01:17 PM
A formula to return value based on the sex, age and BMI of a person Return Max Text or Number Value based on Criteria kwilson307 Excel 1 04-20-2017 05:07 AM
Index to return value based on 2 conditions george batshon Excel 2 01-28-2017 05:11 AM
A formula to return value based on the sex, age and BMI of a person Help with a formula to return a zero prihia971 Excel 1 10-06-2016 02:17 AM
A formula to return value based on the sex, age and BMI of a person Return List Based On Specific Value Helmszee Mail Merge 1 04-12-2016 02:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft