Posted on 2013-09-30
Medium Priority
Last Modified: 2013-09-30
I am trying to create a formula on a Tab called Static Data that refers to a Tab called International. My formula is:

I am saying If G27 is Blank and G28 is Blank return the No 10, if G27 is not blank and G28 is Blank return the No 5 and if G27 and G28 are not blank Return 0

Any assistance greatly appreciated.
Question by:Jagwarman
  • 2
LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 2000 total points
ID: 39532572

LVL 35

Expert Comment

by:[ fanpages ]
ID: 39532574

I noted your other question earlier today:

"IF AND statement"
[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28253184.html ]

(So I am saying If G27 is Blank and G28 is Blank return the No 10 but if G27 is not blank return the No 5)

The answer you received (from Kevin) was:


Just to confirm:

Your revised requirements do not need to use the [InternationalChecklist] worksheet?  Is that correct?


LVL 11

Expert Comment

by:John Easton
ID: 39532580
I think you are looking for something like:

Open in new window

This should return the following:

G27 = Blank and G28 = Blank  Return 10
G27 = Not Blank and G28 = Blank  Return 5
G27 = Blank and G28 = Not Blank Return Blank
G27 = Not Blank and G28 = Not Blank  Return 0
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39532613
Well done, again, Kevin ;)

At least I don't feel bad because my question was ignored.  Everybody was.

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 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