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
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.
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:
- Some help needed about IF function with dates
- Accessor function c++ - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Network card function - Guide
- Excel if function with dates - Guide
2 responses
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Jul 5, 2013 at 01:57 AM
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
replace with the below code
=IF(H1<=DATE(1988,6,30),d11-e11,"0")
Hope your problem solve if not please inform
Thanks
Patnaik
rizwan32
Posts
2
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 5, 2013
Jul 5, 2013 at 03:45 AM
Jul 5, 2013 at 03:45 AM
thanks patnaik my problem is solved and its working fine now.
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Jul 5, 2013 at 04:08 AM
Jul 5, 2013 at 04:08 AM
Glad your problem solve