+ Reply to Thread
Results 1 to 3 of 3

Working out a BMR formula

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Plymouth
    MS-Off Ver
    Excel 2021
    Posts
    96

    Working out a BMR formula

    Hello I am Trying to use a formula in my sheet.


    In a non excel format it would look like this
    BMR = 655 + (9.6 x weight in kg) + (1.8 x height in cm) – (4.7 x age in Yrs)

    My attempt in excel looks like this
    =655+(9.6*C7)+(1.8*C6)-(4.7*C5)

    1. Is this the correct way to get the answer I am looking for.

    2. When nothing is inputted C5-C7 I get returned 655. I can see why but I would rather have a blank cell.


    Can someone rearrange the formula for me so it works please?


    Regards
    Attached Files Attached Files

  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,893

    Re: Working out a BMR formula

    Maybe this... whih will remain blank until all three parameters have been entered.

    =IF(OR(C17="",C18="",C19=""),"",655+(9.6*C19)+(1.8*C18)-(4.7*C17))
    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

  3. #3
    Registered User
    Join Date
    10-17-2018
    Location
    Plymouth
    MS-Off Ver
    Excel 2021
    Posts
    96

    Re: Working out a BMR formula

    Quote Originally Posted by Glenn Kennedy View Post
    Maybe this... whih will remain blank until all three parameters have been entered.

    =IF(OR(C17="",C18="",C19=""),"",655+(9.6*C19)+(1.8*C18)-(4.7*C17))
    Superb Thanks

+ 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. Format a part of a text working with only value not working with formula result
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2017, 05:41 AM
  2. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  3. Replies: 3
    Last Post: 05-14-2015, 07:32 AM
  4. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  5. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  6. Replies: 2
    Last Post: 08-17-2012, 08:16 AM
  7. Replies: 2
    Last Post: 08-01-2012, 11:53 AM

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