software

I am totally confused with this function.
when I enter data into the formula pallette I just get both true and
false statements together in the same cell, but not one or the other as
needed.
I have an instruction whereby my function should look like this
=IF(B2=0,quot;Please enter namequot;,quot;quot;) I do not have a clue as to what I
put in the true and what in the false getting desperate can anyone
please Help
Thanking you in anticipation--
nospe
------------------------------------------------------------------------
nospe's Profile: www.excelforum.com/member.php...oamp;userid=34096
View this thread: www.excelforum.com/showthread...hreadid=538682Hi
Her's an example
If your data was in A1 amp; b1 and you wanted them added together if B2=0 (the
statement was true), and if it was false you wanted nothing, you would write
the formula thus:

=IF(B2=0,A1 B1,quot;quot;)

If you wanted the cells added together if it was false and true was nothing,
it would look like this

=IF(B2=0,quot;quot;,A1 B1)

HTH
Michael M

quot;nospequot; wrote:

gt;
gt; I am totally confused with this function.
gt; when I enter data into the formula pallette I just get both true and
gt; false statements together in the same cell, but not one or the other as
gt; needed.
gt; I have an instruction whereby my function should look like this
gt; =IF(B2=0,quot;Please enter namequot;,quot;quot;) I do not have a clue as to what I
gt; put in the true and what in the false getting desperate can anyone
gt; please Help
gt; Thanking you in anticipation
gt;
gt;
gt; --
gt; nospe
gt; ------------------------------------------------------------------------
gt; nospe's Profile: www.excelforum.com/member.php...oamp;userid=34096
gt; View this thread: www.excelforum.com/showthread...hreadid=538682
gt;
gt;

Try
=IF(A17=0),quot;Enter namequot;,quot;------quot;)
Excell seems to have trouble with quot;quot;
Let me know how it goes
quot;nospequot; wrote:

gt;
gt; I am totally confused with this function.
gt; when I enter data into the formula pallette I just get both true and
gt; false statements together in the same cell, but not one or the other as
gt; needed.
gt; I have an instruction whereby my function should look like this
gt; =IF(B2=0,quot;Please enter namequot;,quot;quot;) I do not have a clue as to what I
gt; put in the true and what in the false getting desperate can anyone
gt; please Help
gt; Thanking you in anticipation
gt;
gt;
gt; --
gt; nospe
gt; ------------------------------------------------------------------------
gt; nospe's Profile: www.excelforum.com/member.php...oamp;userid=34096
gt; View this thread: www.excelforum.com/showthread...hreadid=538682
gt;
gt;