Entering a value when 2 criteria are met - Please HELP!!!

[SFCChase]

I'm trying to get a formula that will enter a particular value when 2 specific criteria are met. I've been trying to use an =IF(AND( statement, but so far I keep getting a "the formula you typed contains an error" message.

I need to have cell V9 return a value of 8 if the following conditions are met:
Cell D9 = "SG"
Cell H8 of a different workbook (Called Work Schedule) = 3

I would like the value of V9 to change to 12 if:
Cell D9 = "SG"
Cell H8 of 'Work Schedule' = 19

My formula now looks like this:
=IF(AND(D9="SG",'WORK SCHEDULE'!H8=3,8,IF(AND(D9="SG",'WORK SCHEDULE'!H8=19,12,""))))

But it won't work....what am i doing wrong???

 

[mikerickson]

Try
=IF(D9="SG", IF([WorkSchedule.xlsm]Sheet1!H8=3, 8, IF([WorkSchedule.xlsm]Sheet1!H8=19, 12, "SG, not WorkShed")), "neither")

I freestyled what the formula would show if the specified conditions aren't met.

 

[SFCChase]

Try
=IF(D9="SG", IF([WorkSchedule.xlsm]Sheet1!H8=3, 8, IF([WorkSchedule.xlsm]Sheet1!H8=19, 12, "SG, not WorkShed")), "neither")

I freestyled what the formula would show if the specified conditions aren't met.

The formula gives me a "FALSE" value in the cell if H8 doesn't equal 3 or 19. is there a way to leave it blank?

 

[SFCChase]

nevermind...i had a typo in there
thanks!

 

[SFCChase]

It's giving me a #REF error now....any other suggestions?

 

[SFCChase]

Let me rephrase the original question as well......"Work Schedule" is off a different spreadsheet of the same workbook...it's not a new workbook entirely....not sure if that makes a difference.

 

[mikerickson]

Change the cell references accordingly.