I have 3
columns of data, a sample is below and I wish to work out something
similar to this:

if Column A = Success AND B = Success AND C=Success then Make column D
say "<25 Days"

if Column A = Failure AND B=Success AND C = Success then make column D
say "<35 Days"

if Column A - Failure AND B = Failure AND C = Success then make column D

say "<45 Days"


By themselves each line will say something like this but don't know how
to tag all 3 together:

=IF(AND(AP2="Failure",AQ2="Failure",AR2="Success") ,"25 Days
Plus","Open")

Rather than use a logical expression with individual cells, you could concatenate the three:
AP2 & AQ2 & AR2
Then you could use VLOOKUP(AP2 & AQ2 & AR2, ... ) to choose the result from a table. There are only 8 possibilities.