Solved

IF condition false copy to other columns

Posted on 2016-08-07
6
27 Views
Last Modified: 2016-08-08
I had this question after viewing Backup Tapes inventory excels function.

Hi Experts,

How we create a condition if the tapes not found,
then it will copy the other cells?

Thanks in advance
Javakit
tapeinventoryV1.xlsx
0
Comment
Question by:javakit1969
  • 3
  • 3
6 Comments
 
LVL 17

Accepted Solution

by:
Roy_Cox earned 500 total points
ID: 41746147
Try

=IF(D2="Not Found",A2,"") in column F & copied down
0
 

Author Comment

by:javakit1969
ID: 41746181
Hi Roy_Cox

Thanks for the solution.
=IF(D:D="Not Found",B2,"")

Javakit
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41746212
Pleased to help
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:javakit1969
ID: 41746666
hi
I had follow the condition and copy down.
but it not copy the not found items
it just copy the last few cells.
Any solution for this ?

thanks in advance
javakit
0
 

Author Comment

by:javakit1969
ID: 41746710
hi

I mange use isnumber to solve the problem.

thanks
javakit
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41747494
I can't see why ISNUMBER was needed. If the cell in D is empty then there may be an issue. If this is the case try

=IF((OR(D2="Not Found",D2="")),A2,"")
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to read BOM (Byte Order Mark) from csv file. 4 35
Excel VBA - Get files in a folder 5 78
Boolean help 6 27
remove lower case characters in excel formula 12 0
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

943 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

3 Experts available now in Live!

Get 1:1 Help Now