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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
Try this formula in J2, Sharen:
=if(isblank(F2),G2,F1&" "&F2)
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Sharen" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks