• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 39
  • Last Modified:

IF condition false copy to other columns

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
javakit1969
Asked:
javakit1969
  • 3
  • 3
1 Solution
 
Roy CoxGroup Finance ManagerCommented:
Try

=IF(D2="Not Found",A2,"") in column F & copied down
0
 
javakit1969Author Commented:
Hi Roy_Cox

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

Javakit
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
javakit1969Author Commented:
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
 
javakit1969Author Commented:
hi

I mange use isnumber to solve the problem.

thanks
javakit
0
 
Roy CoxGroup Finance ManagerCommented:
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
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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