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

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

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. In cell F14 try

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

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

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. Originally Posted by NoS
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. Originally Posted by Pecoflyer
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
•