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.

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.