|two ways of achieving this that I am aware of|
As long as something completely difference does not occur when the value is equal to 2 the above will work. if something different happens, then you will need to use another if statement to hand that condition.
=if(A1=2,(place vbalue of 2 formula),(place one of the formulas from above))
Wow a lot has happened since I started typing this.