Solved

Formula Revision, Need =IF Formula

Posted on 2013-01-17
5
348 Views
Last Modified: 2013-01-17
Hello Experts,

The formula I am using is this,...

="Bag Size: "&SUM(B3+1)&"""W x "&SUM(C3+1)&"""D x "&SUM(D3+C3+6)&"""L"

What I would like, is for my formula to check 3 cells.  IF they ALL have values then the formula above goes into action.  Otherwise, the cell returns " ".

Thank you in advance for your help!

~ Geekamo
0
Comment
Question by:Geekamo
  • 4
5 Comments
 
LVL 1

Author Comment

by:Geekamo
ID: 38790264
Oops, I could have been a little more specific.  The cells it needs to check, are the ones I'm referencing in the formula.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 38790282
Hello,

maybe

=if(count(B3:D3)=3,"Bag Size: "&SUM(B3+1)&"""W x "&SUM(C3+1)&"""D x "&SUM(D3+C3+6)&"""L","")

By the way, you don't need SUM(B3+1), you can just use B3+1, like

=if(count(B3:D3)=3,"Bag Size: "&B3+1&"""W x "&C3+1&"""D x "&D3+C3+6&"""L","")

cheers, teylyn
0
 
LVL 1

Author Comment

by:Geekamo
ID: 38790290
@ teylyn,

I am *very much* a newb when it comes to writing any formula beyond the very basics.  lol Thank you for the tip on the sum.  In looking at your solution, I would if it should be something like =>1. I'll try this out.

~ Geekamo
0
 
LVL 1

Author Comment

by:Geekamo
ID: 38790292
* I wonder
0
 
LVL 1

Author Comment

by:Geekamo
ID: 38790298
@ teylyn,

Ignore my comment.  :)  I didn't understand that right.  This worked perfectly!

~ Geekamo
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question