View Single Post
  #3   Report Post  
K.S.Warrier
 
Posts: n/a
Default

hi,
You may write the formula on the next cell as
=if(L3780="applications","Global Trade SV",L3780),if you want L3780
there.Otherwise,if you want blank cell,if the condition is not satisfied ,then
=(if(l3780="applications","Global trade SV","")

"Dmorri254" wrote:

HI,

I want to say if L3780 = "applications", then replace it with
"Global Trade SV"

Since there is a formula in the field, I need to place this as a
condition...can anyone help me??

Thanx