Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Some help needed about IF function with dates [Solved/Closed]

Report
Posts
2
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 5, 2013
 -
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 -
Hello,

i m making a sheet with this function

=IF(H1<=DATE(1988,6,30),"d11-e11","0")
in this function when date in equal or less then 30-6-88 then it should give difference between two amount placed in d11 and e11 or 0 vice verse but it didn't giving amount difference instead it giving d11-e11 in case of first condition and 0 in second.
can anyone point me out where im mistaking in this function.
thanks.


2 replies

Answer 1 / 2
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 44
Hi

replace with the below code

=IF(H1<=DATE(1988,6,30),d11-e11,"0")

Hope your problem solve if not please inform

Thanks

Patnaik
Answer 2 / 2
Posts
2
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 5, 2013
thanks patnaik my problem is solved and its working fine now.
Report
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 44
Glad your problem solve
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!