Inserting a written formula using the IF function & cell references

I am looking to enter a written formula using cell references/ the IF function. For example,

If Cell A1 = 5
A2 = home
A3 = Heat


I want to know if cell A1 > 1 (true in this case), the written formula "site=A2 and team=A3" will appear. I have a pretty good understanding of the IF function, however I am not aware of how to insert words that are appropriate with a certain cell. I hope this makes sense, if not, I can try and re word it again lol

thanks

An example of the information im looking for is provided below.

What I want is this:
If cell B1 > 0, I want the formula "site=B4 and team=B2 and p:B3 and p:lineB5 and p:marginB6 and line>=(B7-2.5) and line<=(B7+2.5)" to appear. However instead of the cell references being written, I would like the equation to show up as: "site=home and team=Heat and p:away and p:line<0 and p:margin>0 and line>=-6 and line<=-1"

Hope this is a little clearer

Any help would be greatly appreciate. Thanks!

Originally Posted by FDibbins

Hi and welcome to the forum

It looks like you didnt quite finish off the last part (the line part), but take a look at his and extend as needed...

=IF(B1>0,"Site="&B4&" and team="&B2&" and p:"&B3&" and p:line"&B5&" and p:margin"&B6&" and line")

Thankyou very much @FDibbins. Exactly what I was looking for