Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Please advise
Q1: When applying the formula, D will show -38 but i need excel to change it to zero and recongized it as number zero, otherwise when I multiple other cell with this cell it will give value - Example 1. Q2: However, I would also need cell D1 to reflect the number if it is not zero or negative number - Example 2 Example 1 A1 - 01 Mar 2001 (Start Date) B1 - 01 Mar 2006 (End Date) C1 - 31 May 2008 (Audit Date) D1 - (YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1) = 0 instead of -38 Example 2 A1 - 01 Mar 2001 (Start Date) B1 - 01 Jun 2010 (End Date) C1 - 31 May 2008 (Audit Date) D1 - I had this formula in cell D1: (YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1) = 25 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to substract for lunch on =MOD function | Excel Worksheet Functions | |||
How do I substract numbers in range like this: Substract(a1..a10) | New Users to Excel | |||
how do I substract | New Users to Excel | |||
Can you substract dates? | Excel Worksheet Functions | |||
how do i substract in microsoft excel? | Excel Worksheet Functions |