I want to insert actual formulas in to cells instead of the answer to the formula (excel)?

Question

example =if(f2>$3$ etc etc. instead of the possible answer to the if statement i want to put the formula in the cell and if the formula applies to a row of cells how do I do that?without retyping everything

Answer 1

Copy the formula, then select the cells in the row you want, and paste it...Excel should apply the formula to the corresponding columns.

Answer 2

If you are using cell references like $A$1 for example, then these are called ABSOLUTE references. They will not change when you copy the cell around. If you remove $$ then it is a RELATIVE reference.



You can do many things with IF formulas. The easiest way is to have a basic test, such as:



=IF(A1>B1,C1,D1), which would return whatever is in cell C1 or D1, depending on the size of A1 versus B1.



But you can also have a compound IF statement, such as:

=IF(A1 > IF(Name="Jones",B1,C1), "The cell wasn't greater than either")



This formula would test A1 against B1, unless the person's name was Jones, in which case it would test against C1. If A1 was smaller than the appropriate test, it would return that statement.

Answer 3

click and drag. it that dosent help try asking excel how to move formulas. the paper clip should be able to help you

Answer 4

Copy the text and right click in the cells where you want to paste the same format and choose

paste special-choose format only.



YOU R ALL SET -THANKS