Formula Simplification If/Or/And/Then/Else

Is there a way to simplify this formula / make it more efficient???

It will be repeated every row for about 100 rows

Please Login or Register  to view this content.

You could do this:

=IF(OR(AND(J15<=150,J15>0),J15="Letter"),(1+Info!D13)*SUM(P15*(1-X15),R15:U15),"")

which will return a blank instead of FALSE if the conditions are not met.

Hope this helps.

Pete

Pete for the win! thank you!!!

You're welcome - thanks for the rep.

Pete