Results 1 to 6 of 6

Thread: help with IF or IFERROR formula - want a blank cell if no data has been entered

  1. #1

    help with IF or IFERROR formula - want a blank cell if no data has been entered



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I am working on spreadsheet for my daughter's fitness business. We are almost done with it. Our concern now is row 14 INCHES +/-. She has added one more calculation - calculating the total number of inches lost or gained. I think I have the calculation for that specific concern --- basing that on data from Circumference data immediately below. C14 works. D14 - she doesn't care about so we have no formula there. We totaled E15:E23 to give us a number of inches measured. (In the end we don't want the number to show). Beginning F14, we want to calculate the difference between the total number of inches in the preceding column. I have figured that out (I think). We want to drag the formula out but have a blank cell show up and not 0 or VALUE# or whatever. I am attaching spreadsheet. Thank you so much! You are all wonderful!!Book1 - fitness help.xlsx

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    In cell F14 try

    =IF(SUM(F15:F23)=0,"",SUM(F15:F23)-SUM(E15:E23))

  3. #3
    thank you so much! I had gotten close!

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Glad I could help.

    Here is a link to a site you may find useful when struggling with functions
    http://www.techonthenet.com/excel/fo...ndex_alpha.php

    I notice that you did use column ZZ in your formulas to be sure your right most column with data would be captured by the formulas.
    Just curious if you realize how far ZZ is into the future. (Not that it matters)
    If you add info at a rate of 1 column per month, you'll be good for about 58 years.

  5. #5
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,512
    Articles
    0
    Excel Version
    2010 on Xubuntu

    Talking

    Quote Originally Posted by NoS View Post
    If you add info at a rate of 1 column per month, you'll be good for about 58 years.
    Nice one ! Being 63 I'll be dead by then ( but then will XL also probably)

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    780
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Pecoflyer View Post
    Nice one ! Being 63 I'll be dead by then ( but then will XL also probably)
    Hey, Ive got 4 years on you !


Posting Permissions

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