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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks