View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default HOW DO I ... (ASAP PLEASE!!!)

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