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
javakit1969Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Roy CoxConnect With a Mentor Group 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
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
All Courses

From novice to tech pro — start learning today.