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