If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
evaluate
I saw a worksheet for training programs in which this formula is written
=IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) can the function C6EDATE(C6,12) can ever be true as the logic is refering to the same cell afd |
#2
|
|||
|
|||
evaluate
No, I don't see how that could ever be True.
-- Rick (MVP - Excel) "afdmello" wrote in message ... I saw a worksheet for training programs in which this formula is written =IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) can the function C6EDATE(C6,12) can ever be true as the logic is refering to the same cell afd |
#3
|
|||
|
|||
evaluate
On Sun, 16 May 2010 20:55:47 +0300, "afdmello" wrote:
I saw a worksheet for training programs in which this formula is written =IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) can the function C6EDATE(C6,12) can ever be true as the logic is refering to the same cell afd In addition to agreeing with Rick's comment, I would also point out that the first conditional does not compare C5 with a date, but rather compares C5 with 0.000525762 (which is 1 divided by 1902) --ron |
#4
|
|||
|
|||
evaluate
a worksheet for training programs in which this formula is written
=IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) If it's for training purposes then maybe it's being used as an example of how not to write a formula! IF(C6EDATE(C6,12) will *never* be TRUE. There are only 2 possible results, either FALSE or an error. Here's what that is saying in plain English... If the value of cell C5 is less than 1 divided by 1 divided by 1902 then return 0. If the value of cell C5 is not less than 1 divided by 1 divided by 1902 then test the value of cell C6 to see if it is greater than the date of C6 12 months later. If C6 is greater than the date of C6 12 months later return 0 otherwise return 1. 1 divided by 1 divided by 1902 = 0.000525762355415352 It would be technically possible for C5 to be less than 0.000525762355415352. That portion of the formula should be written like this: =IF(C5DATE(1902,1,1),0... Or the preferred method, use a cell to hold the date then refer to that cell: C4 = 1/1/1902 =IF(C5C4,0... Let's assume C6 holds the date 1/1/2010. EDATE(C6,12) = 1/1/2011 So: 1/1/2010 1/1/2011 is not possible and will never be TRUE. It's hard to say what was meant by: IF(C6EDATE(C6,12)... -- Biff Microsoft Excel MVP "afdmello" wrote in message ... I saw a worksheet for training programs in which this formula is written =IF(C51/1/1902,0,IF(C6EDATE(C6,12),0,1)) can the function C6EDATE(C6,12) can ever be true as the logic is refering to the same cell afd |
Thread Tools | |
Display Modes | |
|
|