I want to be able to place an x in a column only if three criterias are met:


currently in column 0 i have a number of days past due - if column O is
between 21 and 27 days then it meets the criteria. I use this formula for
that:
=IF(O5<21,"",IF(O5<28,"X",""))

In column M I have a date field - if the date in column M is greater
then today then it meets the criteria.

In column Q I have a number value - if the value here is 100,000 or
greater then it meets the criteria

If all three conditions are met then I want an x to go in column
otherwise i want it left blank

Can someone help me with a formula for this?

Thanks!