x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 379

# Formula Revision, Need =IF Formula

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 " ".

~ Geekamo
0
Geekamo
• 4
1 Solution

Author Commented:
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

Microsoft MVP ExcelCommented:
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

Author Commented:
@ 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

Author Commented:
* I wonder
0

Author Commented:
@ teylyn,

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

~ Geekamo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.