software

I think I'm losing my mind....

........C...................D..................... ......E.........
1......1............10/25/2005...........10/26/2005
2......2............10/27/2005...........10/29/2005
3......0............10/29/2005...........10/29/2005
4......3............10/29/2005...........11/01/2005

This is how the data SHOULD look.

Column C is the duration of the project in days. Column D is the
project start date. Column E is the project end date.

In Column D I'm using the formula =IF(logical test,value if true,value
if false). As example, in D4 I'm using the formula
=IF(C3=quot;0quot;,E3 0,E3 1).

In my limited understanding, this is supposed to mean that if C3 is a
0, then D4 will report 10/29/2005, BUT if C3 is a number other than 0,
then D4 will report 10/30/2005.

Here is the issue: the formula =IF(C3=quot;0quot;,E3 0,E3 1) is ignoring the
E3 0 part - it ALWAYS adds 1 day to the duration,even when the C3=0.
Also, I tried flipping the true-false values by using
=IF(C3=quot;0quot;,E3 1,E3 0). In that case it ALWAYS adds 0 days to the
duration, even when the value is something other than 0.

Any help would be GREATLY appreciated. I know it must be my
misunderstanding how this formula is supposed to work.

Christine--
chaminod
------------------------------------------------------------------------
chaminod's Profile: www.excelforum.com/member.php...oamp;userid=18163
View this thread: www.excelforum.com/showthread...hreadid=493465
Christine,

If your formula has the value zero in quotes

=IF(C3=quot;0quot;,....)

and C3 has numeric data, it will always be false and return the
calculation for the false return. Try taking your qotation marks out
of the formula so

=IF(C3=0,....)

The quotation marks make excel look for a text value not a numeric
value.Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=493465Get rid of the quotes: =IF(C3=0,E3 0,E3 1) - remember to format the cell as
date otherwise a serial number will show. And since adding 0 does nothing,
you could use =IF(C3=0,E3,E3 1)
Or, get rid of the IF and use =E3 (C3gt;0)

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;chaminodquot; gt; wrote in
message ...
gt;
gt; I think I'm losing my mind....
gt;
gt; .......C...................D...................... .....E.........
gt; 1......1............10/25/2005...........10/26/2005
gt; 2......2............10/27/2005...........10/29/2005
gt; 3......0............10/29/2005...........10/29/2005
gt; 4......3............10/29/2005...........11/01/2005
gt;
gt; This is how the data SHOULD look.
gt;
gt; Column C is the duration of the project in days. Column D is the
gt; project start date. Column E is the project end date.
gt;
gt; In Column D I'm using the formula =IF(logical test,value if true,value
gt; if false). As example, in D4 I'm using the formula
gt; =IF(C3=quot;0quot;,E3 0,E3 1).
gt;
gt; In my limited understanding, this is supposed to mean that if C3 is a
gt; 0, then D4 will report 10/29/2005, BUT if C3 is a number other than 0,
gt; then D4 will report 10/30/2005.
gt;
gt; Here is the issue: the formula =IF(C3=quot;0quot;,E3 0,E3 1) is ignoring the
gt; E3 0 part - it ALWAYS adds 1 day to the duration,even when the C3=0.
gt; Also, I tried flipping the true-false values by using
gt; =IF(C3=quot;0quot;,E3 1,E3 0). In that case it ALWAYS adds 0 days to the
gt; duration, even when the value is something other than 0.
gt;
gt; Any help would be GREATLY appreciated. I know it must be my
gt; misunderstanding how this formula is supposed to work.
gt;
gt; Christine
gt;
gt;
gt; --
gt; chaminod
gt; ------------------------------------------------------------------------
gt; chaminod's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18163
gt; View this thread: www.excelforum.com/showthread...hreadid=493465
gt;

Thanks so much for both of your speedy replies. Works great. I feel
silly for such a basic question, but SO thrilled the Excel wizards out
there are kind enough to set me straight!

Thanks again! This site has been most helpful over the last few
months.--
chaminod
------------------------------------------------------------------------
chaminod's Profile: www.excelforum.com/member.php...oamp;userid=18163
View this thread: www.excelforum.com/showthread...hreadid=493465Try taking the quotes off the zero in your formula.........

=IF(C3=0,E3 0,E3 1)

Vaya con Dios,
Chuck, CABGx3quot;chaminodquot; wrote:

gt;
gt; I think I'm losing my mind....
gt;
gt; ........C...................D..................... ......E.........
gt; 1......1............10/25/2005...........10/26/2005
gt; 2......2............10/27/2005...........10/29/2005
gt; 3......0............10/29/2005...........10/29/2005
gt; 4......3............10/29/2005...........11/01/2005
gt;
gt; This is how the data SHOULD look.
gt;
gt; Column C is the duration of the project in days. Column D is the
gt; project start date. Column E is the project end date.
gt;
gt; In Column D I'm using the formula =IF(logical test,value if true,value
gt; if false). As example, in D4 I'm using the formula
gt; =IF(C3=quot;0quot;,E3 0,E3 1).
gt;
gt; In my limited understanding, this is supposed to mean that if C3 is a
gt; 0, then D4 will report 10/29/2005, BUT if C3 is a number other than 0,
gt; then D4 will report 10/30/2005.
gt;
gt; Here is the issue: the formula =IF(C3=quot;0quot;,E3 0,E3 1) is ignoring the
gt; E3 0 part - it ALWAYS adds 1 day to the duration,even when the C3=0.
gt; Also, I tried flipping the true-false values by using
gt; =IF(C3=quot;0quot;,E3 1,E3 0). In that case it ALWAYS adds 0 days to the
gt; duration, even when the value is something other than 0.
gt;
gt; Any help would be GREATLY appreciated. I know it must be my
gt; misunderstanding how this formula is supposed to work.
gt;
gt; Christine
gt;
gt;
gt; --
gt; chaminod
gt; ------------------------------------------------------------------------
gt; chaminod's Profile: www.excelforum.com/member.php...oamp;userid=18163
gt; View this thread: www.excelforum.com/showthread...hreadid=493465
gt;
gt;