Prev: How do you do an IF statement in Excel comparing three columns
Next: what is ^ function
From: Gord Dibben on 2 Feb 2010 16:03
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." <Robb.S..5ae36ea(a)excelbanter.com> wrote in message
>> news:Robb.S..5ae36ea(a)excelbanter.com...
>>>
>>> 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

From: Ron Coderre on 2 Feb 2010 15:20

Perhaps something like this:
=IF(A1<>"",100,"")

Does that help?


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: 1451
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=175715

[url=&quot;http://www.thecodecage.com&quot;]Microsoft Office Help[/url]

First  |  Prev  | 
Pages: 1 2
Prev: How do you do an IF statement in Excel comparing three columns
Next: what is ^ function