Inserting formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Put the formula in another cell -- for example, X1; then you can specify the
first formula as =IF(A5=1,10,X1)

Regards,
Wes
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISNUMBER Function 2
Excel formula, sum the value cell and if empty cell left blank 0
Sumproduct - Condition based on lookup of a Lookup 12
Complex SUMIF/COUNT IF 5
formula question 2
Best way to insert rows 5
Formula Question 2
ActiveCell.FormulaR1C1 3

Back
Top