| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I ... (ASAP PLEASE!!!)
.... write the formula for the following in cell K23:
If A23 has a name entered, k23 returns $10; otherwise, k23 is blank. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I ... (ASAP PLEASE!!!)
These may help you out.
=IF(COUNTIF(A1,"*")=1,"$10","") =IF(COUNTA(A1)=1,"$10","") HTH Regards, Howard "NewbieNeedsHelp" wrote in message ... ... write the formula for the following in cell K23: If A23 has a name entered, k23 returns $10; otherwise, k23 is blank. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED HELP ASAP PLEASE!! | Excel Discussion (Misc queries) | |||
| NEED ASAP | Excel Discussion (Misc queries) | |||
| NEED HELP ASAP!! | Excel Discussion (Misc queries) | |||
| Need help asap | Excel Discussion (Misc queries) | |||
| I NEED TO KNOW ASAP | Excel Discussion (Misc queries) | |||
Hybrid Mode
