Re: $$Excel-Macros$$ If Condition formula required

2016-03-02 Thread amar takale
Dear Abhishek & Paul Sir, Its really cool formula which exact I want … Now There are a glow on my face. Thanks Once again both of you Sirji. Regards AmarT On Wed, Mar 2, 2016 at 5:57 PM, Paul Schreiner wrote: > It looks like your formula is working as expected (?) > > You're using: > =IF

Re: $$Excel-Macros$$ If Condition formula required

2016-03-02 Thread Paul Schreiner
It looks like your formula is working as expected (?) You're using:=IF(AND(C12="",D12=""),"",IF(C12<>"",C12,D12)) Based on your logic:If both C & D are blanks, return blank. If C has a value and D doesn't, return C. If D has a value and C doesn't, return D. If both C & D has a value, return C. is a

Re: $$Excel-Macros$$ If Condition formula required

2016-03-01 Thread Abhishek Jain
Please see attached. HTH On Wed, Mar 2, 2016 at 10:28 AM, amar takale wrote: > Dear Paul Sir > > Pls look into this topic.I think we will use (If+Search) formula but I > cant possible how to modified it. > > Regards > Amar > > On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote: > >> >> -- >> A

Re: $$Excel-Macros$$ If Condition formula required

2016-03-01 Thread amar takale
Dear Paul Sir Pls look into this topic.I think we will use (If+Search) formula but I cant possible how to modified it. Regards Amar On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote: > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Joi

$$Excel-Macros$$ If Condition formula required

2016-02-29 Thread amar takale
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F