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.
|