Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function for Text
Is it possible to create a formula that would copy text from cell A1 to cell
C1 if cell B1 is blank and if cell B1 has text in it to copy it to cell C1? If so, could someone tell me how? Thanks, Erin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function for Text
=IF(B1="",A1,B1)
-- David Biddulph "Erin" wrote in message ... Is it possible to create a formula that would copy text from cell A1 to cell C1 if cell B1 is blank and if cell B1 has text in it to copy it to cell C1? If so, could someone tell me how? Thanks, Erin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |