IF function

N

nospe

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
 
M

Michael M

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
 
Top