I am trying to use a formaul which looks at the contents of a cell,
however,
is it possible to construct a formula which is not case sensative?

E.g. does A1 contain "dog" - I want true if contains "DOG", "Dog" or "dog"

If your example is all you want to do (that is, do a case-insensitive search
for some text in other text that returns TRUE or FALSE), you could do
this...

=NOT(ISERR(SEARCH("dog",A1)))

Rick