Prev: Spreadsheet Stuck
Next: route to recipient function not working with Windows7
From: NewbieNeedsHelp on 24 Jan 2010 20:19
.... write the formula for the following in cell K23:

If A23 has a name entered, k23 returns $10; otherwise, k23 is blank.

Thank you!
From: Joe User on 24 Jan 2010 20:25
"NewbieNeedsHelp" wrote:
> ... write the formula for the following in cell K23:
> If A23 has a name entered, k23 returns $10; otherwise, k23 is blank.

Perhaps put the following formula into K23:

=if(A23="", "", 10)

formatted as Currency or Accounting with 0 decimal places.
From: L. Howard Kittle on 24 Jan 2010 20:34
These may help you out.

=IF(COUNTIF(A1,"*")=1,"$10","")
=IF(COUNTA(A1)=1,"$10","")

HTH
Regards,
Howard

"NewbieNeedsHelp" <NewbieNeedsHelp(a)discussions.microsoft.com> wrote in
message news:824C04C0-A0F5-474D-BF3B-A1C10AB6CF1B(a)microsoft.com...
> ... write the formula for the following in cell K23:
>
> If A23 has a name entered, k23 returns $10; otherwise, k23 is blank.
>
> Thank you!


 | 
Pages: 1
Prev: Spreadsheet Stuck
Next: route to recipient function not working with Windows7