5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Can anyone turn these 11 words into a formula (for a spreadsheet)?

by Thomas
4 replies
  • OFF TOPIC
    • |
Hello Warriors:

I've always been pretty clueless when it comes to spreadsheet formulae, so this is probably seems like a very basic question to those who know such things, but...

How do you turn this into a formula:
If A1 is NOT blank then insert XYZ in this cell
A1 is a relative cell reference, and XYZ is simply text (and is the same for every instance of the formula).

(If it matters: if A1 IS blank, then the cell in which the formula is placed will also remain blank.)

Thanks for letting me pick your brains...

Tommy.
  • Profile picture of the author Ken Strong
    Doesn't it make a difference which kind of spreadsheet you're using? Is this for Excel or something else?
    Signature
    {{ DiscussionBoard.errors[2808770].message }}
  • Profile picture of the author KenThompson
    1. If A1 is NOT blank then insert XYZ in this cell.
    2. If A1 IS blank, then the cell in which the formula
    is placed will also remain blank. (it matters)

    =IF(NOT(A1 = " "),”XYZ”,” ”)

    This is for Excel, and there may be differences in formatting
    for the year - I think. So give it a shot and report back.

    If it doesn't work, we'll blame Kurt.

    IF(NOT(Ax = works great,"Blame Kurt","Ken is cool")


    Ken
    {{ DiscussionBoard.errors[2809568].message }}
    • Profile picture of the author Thomas
      Originally Posted by Ken Strong View Post

      Doesn't it make a difference which kind of spreadsheet you're using? Is this for Excel or something else?
      Seems it does. I didn't realise that when I wrote the OP. It's for Excel, but I use OpenOffice too.

      Originally Posted by KenThompson View Post

      1. If A1 is NOT blank then insert XYZ in this cell.
      2. If A1 IS blank, then the cell in which the formula
      is placed will also remain blank. (it matters)

      =IF(NOT(A1 = " "),"XYZ"," ")

      This is for Excel, and there may be differences in formatting
      for the year - I think. So give it a shot and report back.

      If it doesn't work, we'll blame Kurt.
      Thanks Ken.

      It didn't work though. Kurt must have done something bad.

      However, since I made the OP, I discovered the ISBLANK function, and managed to get this to work:

      For Excel: =IF(ISBLANK(A1)," ","XYZ")
      For OO Calc: =IF(ISBLANK(A1);" ";"XYZ")

      Thanks for the help nevertheless.

      Tommy.
      {{ DiscussionBoard.errors[2812876].message }}
      • Profile picture of the author KenThompson
        Originally Posted by Thomas View Post

        For Excel: =IF(ISBLANK(A1)," ","XYZ")
        For OO Calc: =IF(ISBLANK(A1);" ";"XYZ")

        Thanks for the help nevertheless.

        Tommy.
        Welcome. But I like the Isblank function...

        IF(ISBLANK(Kurt's head),"normal","something's seriously wrong")


        Ken
        {{ DiscussionBoard.errors[2813140].message }}

Trending Topics