Improve company productivity with a Business Account.Sign Up

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

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
0
Geekamo
Asked:
Geekamo
  • 4
1 Solution
 
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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:
@ 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
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now