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

Thank you in advance for your help!

~ Geekamo
LVL 1
GeekamoAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor 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
 
GeekamoAuthor 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
 
GeekamoAuthor 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
 
GeekamoAuthor Commented:
* I wonder
0
 
GeekamoAuthor Commented:
@ teylyn,

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

~ Geekamo
0
All Courses

From novice to tech pro — start learning today.