Solved

if formula compare two columns

Posted on 2014-03-27
3
97 Views
Last Modified: 2014-03-30
Hi expert's excel 2007

Need a formula to do the following
If a2 has the word closed and b2 is blank then c2 return ignore ootherwise if a2 is not closed and b2 is not blank then return ref to mapping table
0
Comment
Question by:route217
3 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 250 total points
Comment Utility
What do you have in the mapping table, and what does "c2 return ignore" mean? Return C2, or return ignore?

=if(and(a2="closed",b2=""),c2,RefToMappingTable)
0
 
LVL 7

Assisted Solution

by:Steve
Steve earned 250 total points
Comment Utility
=IF(AND(A2="closed",B2=""),"ignore","ref")

or possibly....

=IF(AND(A2="closed",B2=""),"","ref")
0
 
LVL 31

Expert Comment

by:Rob Henson
Comment Utility
What about the other combinations of options for A2 & B2?

1) A2 = Closed, B2 = blank - Returns Ignore
2) A2 = Closed, B2 <> blank - ?
3) A2 <> Closed, B2 = blank - ?
4) A2 <> Closed, B2 <> Blank - Reference mapping table

You have covered options 1 & 4, could the others occur?

Thanks
Rob H
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now