Previous Topic Next Topic

Some help needed about IF function with dates

Solved/Closed
rizwan32 Posts 2 Registration date Thursday 4 July 2013 Status Member Last seen 5 July 2013 - 4 Jul 2013 à 12:53
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 - 5 Jul 2013 à 04:08
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.


Related:

2 responses

Réponse 1 / 2
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
5 Jul 2013 à 01:57
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
Réponse 2 / 2
rizwan32 Posts 2 Registration date Thursday 4 July 2013 Status Member Last seen 5 July 2013
5 Jul 2013 à 03:45
thanks patnaik my problem is solved and its working fine now.
sgmpatnaik Posts 52 Registration date Tuesday 2 April 2013 Status Member Last seen 27 November 2013 45
5 Jul 2013 à 04:08
Glad your problem solve

Similar discussions

Using IF function with dates
dkayeh1 -
RayH -

18 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses