From: Robb S. on 2 Feb 2010 14:44 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. From: Otto Moehrbach on 2 Feb 2010 15:16 =If(B2="",True,False) Note that there is no space between the 2 quotes. HTH Otto "Robb S." 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 > > > > > -- > Robb S. From: "David Biddulph" groups [at] on 2 Feb 2010 15:30 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 > 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 >> >> >> >> >> -- >> Robb S. From: Gord Dibben on 2 Feb 2010 15:35 =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 From: Mike H on 2 Feb 2010 15:43 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. > . >  |  Next  |  Last