Benches Uncategorized

5

Assigning a Value to Text

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Okay so I am new to numbers and still trying to figure out a few things. My problem is I am trying to assign a value to text. It's nothing complicated I'm just trying to create a work schedule and I want a value of 1 (indicating 1 hour) assigned to each cell that has text in it.

For instance John Doe is working in the office from 8-1. Each column has a heading that indicates that hour and each row is assigned to one employee. I'd like to highlight from 8-1 for John and insert the text "Office" in each cell and have it calculated at the end as 5 hours (1 for each cell that has the text office).

Thanks for the help!

Amsel

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    As far as I know, the spreadsheet doen't behave this way.

    Highlighting a cell or a range of cells is not sufficient to trigger a function.

    User uploaded file

    In column D the formula is:

    =IF(C=TRUE,"Office","")

    in the footer cell of column D the formula is:

    =COUNTIF(D,"Office")

    Yvan KOENIG (from FRANCE vendredi 15 août 2008 15:03:41)

  2. 0

    Amsel

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you for the help. I know it is possible to assign a number to certain text using excel (eg "office" = 1 or "dl" = 3) & I was just trying to see if I could do the same in Numbers.

  3. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Think different 😉

    Yvan KOENIG (from FRANCE vendredi 15 août 2008 19:20:16)

  4. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    This should be the same in Numbers or Excel. Create a lookup table then display the number based on cell values. (VLOOKUP, LOOKUP, etc..)

    Regards,

  5. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I, too, am skeptical that Excel has any better way to doing the calculation that you describe than Numbers has. For instance, Yvan's summary formula could simply become: =COUNTIF(D,"Office")*1 + COUNTIF(D, "dl")*3) to accomplish the weighting of 1 for "Office" and 3 for "dl".

    Jerry