I want to return a formula instead of a value in an IF function

[Guest]

I need a cell to return a answer from a formula if a certain cell contains certain text and if it doesn't it needs to return a answer from a different formula. Can anything be done?

 

[Frank Kabel]

Hi
try
=IF(A1="some text",formula_1,formula_2)

 

[Guest]

Thanks Frank but I have tried that. What happens is after you enter that it wants to put quotes around my formulas. So it pastes the formula in that cell rather than the answer

 

[Frank Kabel]

Hi
what other formulas are you trying to use. You may post your curretn
example