|
| 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
October 9th, 2009, 10:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Error
Ok, i've been posting today about the following formula, which was giving me
a "VALUE!" error. We figured out that it was because one of the cells had a space in it. But once i went in and took the space out (so there is a value in the more current date's cell but no value in the older date's cell), it is now giving me an answer of 1293 for the difference between the two cells. =IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"" ,DATEDIF(Z2133,AD2133,"m"))) AD2133 has a value of 2007-10-10 and Z2133 is blank 
|
|
#2
October 9th, 2009, 11:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
I've just realized it's happening every time that there's a value in the AD
column and not in the Z column and i'm pretty sure it's because my formula doesn't tell it to remain blank in this case. But i don't know how to change the formula to make it work. "Shannan" wrote: Ok, i've been posting today about the following formula, which was giving me a "VALUE!" error. We figured out that it was because one of the cells had a space in it. But once i went in and took the space out (so there is a value in the more current date's cell but no value in the older date's cell), it is now giving me an answer of 1293 for the difference between the two cells. =IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"" ,DATEDIF(Z2133,AD2133,"m"))) AD2133 has a value of 2007-10-10 and Z2133 is blank
|
|
#3
October 9th, 2009, 11:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
=IF(or(AD2133,z2133)="","",IF(DATEDIF(Z2133,AD2133 ,"m")=0,"",DATEDIF(Z2133,AD2133,"m")))
-- pleae click yes if it was helpfull regards from Brazil Marcelo "Shannan" escreveu: I've just realized it's happening every time that there's a value in the AD column and not in the Z column and i'm pretty sure it's because my formula doesn't tell it to remain blank in this case. But i don't know how to change the formula to make it work. "Shannan" wrote: Ok, i've been posting today about the following formula, which was giving me a "VALUE!" error. We figured out that it was because one of the cells had a space in it. But once i went in and took the space out (so there is a value in the more current date's cell but no value in the older date's cell), it is now giving me an answer of 1293 for the difference between the two cells. =IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"" ,DATEDIF(Z2133,AD2133,"m"))) AD2133 has a value of 2007-10-10 and Z2133 is blank
|
|
#4
October 9th, 2009, 11:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
If i do this formula, then when both columns AD and Z are blank, i get a
"#VALUE!" error. "Marcelo" wrote: =IF(or(AD2133,z2133)="","",IF(DATEDIF(Z2133,AD2133 ,"m")=0,"",DATEDIF(Z2133,AD2133,"m"))) -- pleae click yes if it was helpfull regards from Brazil Marcelo "Shannan" escreveu: I've just realized it's happening every time that there's a value in the AD column and not in the Z column and i'm pretty sure it's because my formula doesn't tell it to remain blank in this case. But i don't know how to change the formula to make it work. "Shannan" wrote: Ok, i've been posting today about the following formula, which was giving me a "VALUE!" error. We figured out that it was because one of the cells had a space in it. But once i went in and took the space out (so there is a value in the more current date's cell but no value in the older date's cell), it is now giving me an answer of 1293 for the difference between the two cells. =IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"" ,DATEDIF(Z2133,AD2133,"m"))) AD2133 has a value of 2007-10-10 and Z2133 is blank
|
|
#5
October 10th, 2009, 05:49 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
Try the below
=IF(COUNT(AD2133,Z2133)2,"",IF(DATEDIF(Z2133,AD2 133,"m")=0,"",DATEDIF(Z2133,AD2133,"m"))) If this post helps click Yes --------------- Jacob Skaria "Shannan" wrote: If i do this formula, then when both columns AD and Z are blank, i get a "#VALUE!" error. "Marcelo" wrote: =IF(or(AD2133,z2133)="","",IF(DATEDIF(Z2133,AD2133 ,"m")=0,"",DATEDIF(Z2133,AD2133,"m"))) -- pleae click yes if it was helpfull regards from Brazil Marcelo "Shannan" escreveu: I've just realized it's happening every time that there's a value in the AD column and not in the Z column and i'm pretty sure it's because my formula doesn't tell it to remain blank in this case. But i don't know how to change the formula to make it work. "Shannan" wrote: Ok, i've been posting today about the following formula, which was giving me a "VALUE!" error. We figured out that it was because one of the cells had a space in it. But once i went in and took the space out (so there is a value in the more current date's cell but no value in the older date's cell), it is now giving me an answer of 1293 for the difference between the two cells. =IF(AD2133="","",IF(DATEDIF(Z2133,AD2133,"m")=0,"" ,DATEDIF(Z2133,AD2133,"m"))) AD2133 has a value of 2007-10-10 and Z2133 is blank
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
