Previous Topic Next Topic

Some help needed about IF function with dates

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

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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

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

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses