Combine 3 different formulas

[thedeadzeds]

Guys, is there a way to combine the following 3 formulas into 1?
[TABLE="width: 223"]
<tbody>[TR]
[TD]

 =IF(J2=Q2," WE LEAD @ £", " BOW £")

[/TD]
[/TR]
</tbody>[/TABLE]

 =IF(R2=J2," LEAVE"," CHANGE TO £")

 =IF(J2=R2,"",R2)

 

[Joe4]

Yes, it is called NESTING If statements. But you need to spell out for us the order of precedence. Also, each has a different FALSE argument, so you need to explain to us how all those should work together.
For example, if the first one is FALSE (if J2 does not equal Q2, do you want it to return " BOW £" or do you want it to go on to the next check?

So you need to clarify how all three of these situations need to interact with each other (from a simple logic standpoint, not a technical one).

If they are all independent, and you want to return all three, then you would simply concatenate them, i.e.

=IF(J2=Q2," WE LEAD @ £", " BOW £") [COLOR=#ff0000]&[/COLOR] IF(R2=J2," LEAVE"," CHANGE TO £") [COLOR=#ff0000]&[/COLOR] IF(J2=R2,"",R2)