Inserting formulas

A

Adam1 Chicago

Is there a way to have an If/Then statement insert a formula? For example,
=if(A5=1,10,"=if(P27>5,"",0)")

Thank you
 
S

SunTzuComm

Put the formula in another cell -- for example, X1; then you can specify the
first formula as =IF(A5=1,10,X1)

Regards,
Wes
 
A

Adam1 Chicago

Thank you. However, this solution gives me the ANSWER for the second IF
statement, I want to insert the actual formula...do you know anyway to do
that?
 
S

Sandy Mann

Hi Adam,

If you mean that you want the cell to contain either the formula
=IF(A5=1,10,"") or =if(P27>5,"",0) then no, I know of no way of doing that.
If you mean that you want the cell to show the contained formula as text
then try

=IF(A5=1,10,"=if(P27>5,"""",0)")


HTH

Sandy
 
Top