If/And formula

[flyeaglesfly]

I need some help figuring out how to get this formula to work. Thank you to anyone who can help.



=IF(AND(OR(C3=P3,C3=P4),G3<=8),IF(AND(E3>=12/24,E3<20/24),P6,IF(AND(OR(C3=P3,C3=P4),G3<=8),IF(AND(E3>=20/24,E3<=24/24),P5,IF(AND(OR(C3=P3,C3=P4),G3<=8),IF(AND(E3>=0/24,E3<6/24),P5,""))))),IF(AND(C3=P7,G3<=8),IF(AND(E3>=12/24,E3<20/24),P9,IF(AND(C3=P7,G3<=8),IF(AND(E3>=20/24,E3<24/24),P8,IF(AND(C3=P7,G3<=8),IF(AND(E3>=0/24,E3<6/24),P8,""),"")),"")),"")),IF(AND(C3=P10,G3<=8),IF(AND(E3>=12/24,E3<20/24),P12,IF(AND(C3=P10,G3<=8),IF(AND(E3>=20/24,E3<24/24),P11,IF(AND(C3=P10,G3<=8),IF(AND(E3>=0/24,E3<6/24),P11,""),"")),"")),"")

[AK262007]

can you upload a copy of the sheet that it is from ? or an example ?

[flyeaglesfly]

I don't know how too. Can you explain how?

[AK262007]

you need to zip the file up then post a reply and use the paperclip to browse then upload the file

[flyeaglesfly]

Sorry it took so long. Thank you for taking a look at it. H3 is the formula I need help with.

[NBVC]

You could possibly shorten it a little to:

=IF(AND(OR(C3=P3,C3=P4),G3<=8),IF(AND(E3>=12/24,E3<20/24),P6,IF(AND(E3>=20/24,E3<=24/24),P5,IF(AND(E3>=0/24,E3<6/24),P5,""))))&IF(AND(C3=P7,G3<=8),IF(AND(E3>=12/24,E3<20/24),P9,IF(AND(E3>=20/24,E3<24/24),P8,IF(AND(E3>=0/24,E3<6/24),P8,""))))&IF(AND(C3=P10,G3<=8),IF(AND(E3>=12/24,E3<20/24),P12,IF(AND(E3>=20/24,E3<24/24),P11,IF(AND(E3>=0/24,E3<6/24),P11,""))))