I am creating an invoice in Excel. I would like to be able to creat a formula that will enter an amount in say column B IF there is ANY text in column A. trying to use the IF function, I don't know what I could put into the "Logical test" box in order to have it accepted. After that, I would put my standard fee amount into the "value if true" line and a space, blank or zero in the "value if false" line. So what would I need to enter into the logical test box to make this happen? The value that will ultimately be in column A will either be ANY date, or ANY NAME.

Help ~ and thanks

Robb

=If(B2="",True,False)
Note that there is no space between the 2 quotes. HTH Otto

"Robb S." wrote in message
...

I am creating an invoice in Excel. I would like to be able to creat a
formula that will enter an amount in say column B IF there is ANY text
in column A. trying to use the IF function, I don't know what I could
put into the "Logical test" box in order to have it accepted. After
that, I would put my standard fee amount into the "value if true" line
and a space, blank or zero in the "value if false" line. So what would
I need to enter into the logical test box to make this happen? The
value that will ultimately be in column A will either be ANY date, or
ANY NAME.

Help ~ and thanks

Robb




--
Robb S.

Or just =B2=""
You don't need the =IF(...,True,False), as you already have a boolean.
--
David Biddulph

Otto Moehrbach wrote:
=If(B2="",True,False)
Note that there is no space between the 2 quotes. HTH Otto

"Robb S." wrote in message
...

I am creating an invoice in Excel. I would like to be able to creat a
formula that will enter an amount in say column B IF there is ANY
text in column A. trying to use the IF function, I don't know what I
could put into the "Logical test" box in order to have it accepted.
After that, I would put my standard fee amount into the "value if
true" line and a space, blank or zero in the "value if false" line.
So what would I need to enter into the logical test box to make this
happen? The value that will ultimately be in column A will either be
ANY date, or ANY NAME.

Help ~ and thanks

Robb




--
Robb S.

=IF(A1="","",21.50)


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 19:44:33 +0000, Robb S.
wrote:


I am creating an invoice in Excel. I would like to be able to creat a
formula that will enter an amount in say column B IF there is ANY text
in column A. trying to use the IF function, I don't know what I could
put into the "Logical test" box in order to have it accepted. After
that, I would put my standard fee amount into the "value if true" line
and a space, blank or zero in the "value if false" line. So what would
I need to enter into the logical test box to make this happen? The
value that will ultimately be in column A will either be ANY date, or
ANY NAME.

Help ~ and thanks

Robb

Hi,

Maybe this

=IF(A1="","","My standard fee amount")

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robb S." wrote:


I am creating an invoice in Excel. I would like to be able to creat a
formula that will enter an amount in say column B IF there is ANY text
in column A. trying to use the IF function, I don't know what I could
put into the "Logical test" box in order to have it accepted. After
that, I would put my standard fee amount into the "value if true" line
and a space, blank or zero in the "value if false" line. So what would
I need to enter into the logical test box to make this happen? The
value that will ultimately be in column A will either be ANY date, or
ANY NAME.

Help ~ and thanks

Robb




--
Robb S.
.

Did I badly misinterpret OP's question?

How does checking B2 have anything to do with a cell in Column A being
empty?

I have re-read the question and stick with my first reply.

=IF(A1="","","whatever")


Gord

On Tue, 2 Feb 2010 20:30:15 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Or just =B2=""
You don't need the =IF(...,True,False), as you already have a boolean.
--
David Biddulph

Otto Moehrbach wrote:
=If(B2="",True,False)
Note that there is no space between the 2 quotes. HTH Otto

"Robb S." wrote in message
...

I am creating an invoice in Excel. I would like to be able to creat a
formula that will enter an amount in say column B IF there is ANY
text in column A. trying to use the IF function, I don't know what I
could put into the "Logical test" box in order to have it accepted.
After that, I would put my standard fee amount into the "value if
true" line and a space, blank or zero in the "value if false" line.
So what would I need to enter into the logical test box to make this
happen? The value that will ultimately be in column A will either be
ANY date, or ANY NAME.

Help ~ and thanks

Robb