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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW DO I ... (ASAP PLEASE!!!) (https://www.excelbanter.com/excel-discussion-misc-queries/254254-how-do-i-asap-please.html)

NewbieNeedsHelp

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!

Joe User[_2_]

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.

L. Howard Kittle

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!

All times are GMT +1. The time now is 09:43 PM.