Combining 2 Formulas

[cjacks9]

I need a mega formula that will combine these two operations. Right now I have to do it in 2 diffrent columns.

=IF(H1>9,MAX(O1:P1))


=IF(AND(H1<9,Q1>9),P1)



H O P Q
# of Cases Log History # of Cases
1 1 0.0% 60.0% 2
2 3 92.3% 82.1% 271
3 1 74.7% 73.0% 11
4 3 0.0% 57.8% 29

[BigBas]

=IF(H1>9,MAX(O1:P1),IF(AND(H1<9,Q1>9),P1))

Try that and let me know if it worls.

[cjacks9]

It worked perfect, thanks a million, that just saved me an unbelievable amount of time.

[BigBas]

Glad I could help.