Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Do I need a formula or Macro?
I want to create a formula or a Macro that will do the following: Look in
cell F2, if it's blank, look one cell to the right, if it contains a value, copy the value in F1 into J2 followed by the data in F2 |
#2
|
|||
|
|||
Put this in J2
=IF(AND(F2="",G2<""),F1&F2,"ConditionNotSpecified ") Of course, if the formula works, then it is because there is nothing in F2 to copy to J2........... Vaya con Dios, Chuck, CABGx3 "Sharen" wrote in message ... I want to create a formula or a Macro that will do the following: Look in cell F2, if it's blank, look one cell to the right, if it contains a value, copy the value in F1 into J2 followed by the data in F2 |
#3
|
|||
|
|||
Try this formula in J2, Sharen:
=if(isblank(F2),G2,F1&" "&F2) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Sharen" wrote in message ... I want to create a formula or a Macro that will do the following: Look in cell F2, if it's blank, look one cell to the right, if it contains a value, copy the value in F1 into J2 followed by the data in F2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on Macro or Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Insert macro into formula | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Fill Formula - Macro | Excel Discussion (Misc queries) |