HOW DO I ... (ASAP PLEASE!!!)

[NewbieNeedsHelp]

.... write the formula for the following in cell K23:

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

Thank you!

 

[Joe User]

... 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.

 

[L. Howard Kittle]

These may help you out.

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

HTH
Regards,
Howard