Excel IF Statement - Multiple conditions in columns

I want to run a logical test that will execute either of two pieces of code based on a boolean outcome in MS Excel.

If I write what I want my code to do in plain English, it might help you understand my goal.

I want my IF statement to find 1 or more instances of a specific value in one column, and the same again in another column and lastly a third column. If these all hold true (and are contained within the same line at least once) then I want to execute another function, and if false a different function will be executed.

I tried the above with an IF and AND and COUNTIF functions that return TRUE if > 0, but my problem is it doesn't link each of these finds to the same record and just returns TRUE if any of these arguments appear.

I'm currently learning programming and Excel so my knowledge is pretty limited right now.

Many thanks.

Fraser