<div>
Oops, I could have been a little more specific. &nbsp;The cells it needs to check, are the ones I'm referencing in the formula.
</div>


Oops, I could have been a little more specific.  The cells it needs to check, are the ones I'm referencing in the formula.

<div>
@ teylyn,<br />
<br />
I am *very much* a newb when it comes to writing any formula beyond the very basics. &nbsp;lol Thank you for the tip on the sum. &nbsp;In looking at your solution, I would if it should be something like =&gt;1. I'll try this out.<br />
<br />
~ Geekamo
</div>


@ 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

<div>
@ teylyn,<br />
<br />
Ignore my comment. &nbsp;:) &nbsp;I didn't understand that right. &nbsp;This worked perfectly!<br />
<br />
~ Geekamo
</div>


@ teylyn,

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

~ Geekamo

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
The formula I am using is this,...<br />
<br />
=&quot;Bag Size: &quot;&amp;SUM(B3+1)&amp;&quot;&quot;&quot;W x &quot;&amp;SUM(C3+1)&amp;&quot;&quot;&quot;D x &quot;&amp;SUM(D3+C3+6)&amp;&quot;&quot;&quot;L&quot;<br />
<br />
What I would like, is for my formula to check 3 cells. &nbsp;IF they ALL have values then the formula above goes into action. &nbsp;Otherwise, the cell returns &quot;&nbsp;&quot;.<br />
<br />
Thank you in advance for your help!<br />
<br />
~ Geekamo
</div>
</div>


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

Formula Revision, Need =IF Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.