return different values based on 4 criteria?

[Susie (SFAngelgirl)]

Need Formula or macro to allocate the "Scheduled hours" based on Group Counts:

If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C"
should both be 6 hours
If Group "A" and "C" are equal to or less than 0, then Scheduled "A" and "C"
should both be 0 hours
If Group "A" greater than 1, and Group "C" is equal to 0, then Scheduled "A"
should 12 hours
If Group "C" greater than 1, and Group "A" is equal to 0, then Scheduled "C"
should 12 hours

What should be returned for Scheduled Hours
Group Count Scheduled Hours
A B A B
1047 1192 6 6
0 995 0 12
1752 0 12 0
0 0 0 0
0 0 0 0

 

[Gary Brown]

- Assume Group A is in column A
- Assume Group C is in column B
- Assume data begins in row 2

- Scheduled Hours for Group A would be...
=IF(AND(A2>0,B2>0),6,IF(AND(A2<=0,B2<=0),0,IF(AND(A2>0,B2=0),12,0)))

-Scheduled Hours for Group C would be...
=IF(AND(A2>0,B2>0),6,IF(AND(A2<=0,B2<=0),0,IF(AND(A2=0,B2>0),12,0)))

 

[Teethless mama]

Scheduled Hours for Group A
=MAX((A2>1)*12-(B2>1)*6,0)


Scheduled Hours for Group C
=MAX((B2>1)*12-(A2>1)*6,0)

 

[Susan in Sacramento]

Teethless Mama provided a MAX function that worked great! I couldn't get
your answer to work just right - but it helped me with anohter nested IF AND
issue. THank you Gary

 

[Susan in Sacramento]

Worked on the first try - thank you - It saved me hours of work