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,"Please enter name","") 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: http://www.excelforum.com/member.php...o&userid=34096
View this thread: http://www.excelforum.com/showthread...hreadid=538682

Hi
Her's an example
If your data was in A1 & 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,"")

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

=IF(B2=0,"",A1+B1)

HTH
Michael M

"nospe" wrote:


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,"Please enter name","") 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: http://www.excelforum.com/member.php...o&userid=34096
View this thread: http://www.excelforum.com/showthread...hreadid=538682

Try
=IF(A17=0),"Enter name","------")
Excell seems to have trouble with ""
Let me know how it goes



"nospe" wrote:


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,"Please enter name","") 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: http://www.excelforum.com/member.php...o&userid=34096
View this thread: http://www.excelforum.com/showthread...hreadid=538682