+ Reply to Thread
Results 1 to 2 of 2

Having trouble with ideal body wight formula

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    NY, USA
    MS-Off Ver
    2015
    Posts
    1

    Having trouble with ideal body wight formula

    I am trying to write a formula to calculate ideal body weight but I am having trouble. I need it to meet the conditions below.

    M = 48 kg for the first 152.4 cm + 1.1 kg for each additional cm and - 0.988 kg for each cm under 152.4.
    F = 45 kg for the first 152.4 cm + 0.9 kg for each additional cm and - 0.344 kg for each cm under 152.4.

    This is what I currently have.

    =IF(F5="F",IF(H5>=152.4,(H5-152.4)*0.9+152.4, 152.4-(152.4-H5)*0.344),IF(H5>=152.4,(H5-152.4)*1.1+152.4,152.4-(152.4-H5)*0.988))


    Thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,894

    Re: Having trouble with ideal body wight formula

    Try this:

    =IF(A3="M",IF(B3-152.4<0,48-0.988*(152.4-B3),48+1.1*(B3-152.4)),IF(A3="F",IF(B3-152.4<0,45-0.344*(152.4-B3),45+0.9*(B3-152.4))))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ideal Body Weight (IBW) Equations w/ Gender and Height Modifiers
    By Mlabrec in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-30-2018, 10:08 AM
  2. Vlookup for multiple resulf
    By mic1412 in forum Excel General
    Replies: 4
    Last Post: 07-22-2017, 01:59 AM
  3. Calculate ideal body weight (IBW) based on multiple conditions
    By smaeralbazz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2016, 02:14 AM
  4. stumped on ideal layout
    By tammym in forum Excel General
    Replies: 1
    Last Post: 07-06-2012, 08:21 PM
  5. use an ideal function to MATCH
    By iliasark in forum Excel General
    Replies: 10
    Last Post: 06-25-2012, 02:14 PM
  6. Picking Ideal Blank size
    By jlhodgson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 06:20 AM
  7. Ideal Tracking Log Help
    By kblaine in forum Excel General
    Replies: 2
    Last Post: 07-28-2011, 08:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1