LinkBack URL
About LinkBacks
garry240868,
Welcome to the Excel Forum.
Try:
In cell B1 enter:
=IF(A1="","","orange")
In cell C1 enter:
=IF(A1="","",1)
Format cell C1 for your currency.
In cell A1 enter:
12345
garry240868,
Welcome to the Excel Forum.
Try:
In cell B1 enter:
=IF(A1="","","orange")
In cell C1 enter:
=IF(A1="","",1)
Format cell C1 for your currency.
In cell A1 enter:
12345
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks just the trick, sorry just one last question I,ve attached the sheet with the source data on is there any way it will recognise different values, for instance if I enter any of the part numbers on the list in A1the cell will update as necessary in B2 & B3 Thanks again
garry240868,
if I enter any of the part numbers on the list in A1the cell will update as necessary in B2 & B3
If I enter in cell A1:
1444CZ
What should go in cell B2 and B3?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks