Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to number value
I'm trying to set up a spreadsheet for shift scheduling. On one spreadsheet
I have shift "titles" and on another I have the hour values for them. I'm trying to make it so when I put in, say, "PM" on Sheet 1 that it shows "4.5" in the same cell for Sheet 2. On sheet 2 I had this: =IF(Shifts!B3="AD","10",IF(Shifts!B3="PM","5.5", IF(Shifts!B3="AM","4.5",IF(Shifts!B3="MID","4",))) ) I try to sum all of the days of the week values and it doesn't find them as numerical values. So, again, I'm trying to do this: "MID"=4 "PM"=4.5 "AM"=4.5 "AD"=5 so that I can add up the values to a grand total. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to number value
Remove the double quotes in your formula from the numbers it is supposed to
return: =IF(Shifts!B3="AD",10,IF(Shifts!B3="PM",5.5,IF(Shi fts!B3="AM",4.5,IF(Shifts!B3="MID",4,0)))) Hope this helps, Hutch "brsc" wrote: I'm trying to set up a spreadsheet for shift scheduling. On one spreadsheet I have shift "titles" and on another I have the hour values for them. I'm trying to make it so when I put in, say, "PM" on Sheet 1 that it shows "4.5" in the same cell for Sheet 2. On sheet 2 I had this: =IF(Shifts!B3="AD","10",IF(Shifts!B3="PM","5.5", IF(Shifts!B3="AM","4.5",IF(Shifts!B3="MID","4",))) ) I try to sum all of the days of the week values and it doesn't find them as numerical values. So, again, I'm trying to do this: "MID"=4 "PM"=4.5 "AM"=4.5 "AD"=5 so that I can add up the values to a grand total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions |