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
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
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
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
--
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