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

  • Thread starter Thread starter NewbieNeedsHelp
  • Start date Start date
N

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!
 
NewbieNeedsHelp said:
... write the formula for the following in cell K23:
If A23 has a name entered, k23 returns $10; otherwise, k23 is blank.
Click to expand...

Perhaps put the following formula into K23:

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

formatted as Currency or Accounting with 0 decimal places.
 
These may help you out.

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

HTH
Regards,
Howard
 
Back
Top