Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas
When place the formula =A1*.25. (If the value place in A1 is 100 than when I
put 100 into the cell I should get 75.) But when I place a value into cell A1 it overwrites my formula and leaves a value of 100 and my formula is missing. Please advise. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas
Are you typing the formula in cell A1 too? If so that is the problem. Try
typing 100 in cell A1, then your formula is cell B1. Your answer will be in cell B1. "Chrissy" wrote: When place the formula =A1*.25. (If the value place in A1 is 100 than when I put 100 into the cell I should get 75.) But when I place a value into cell A1 it overwrites my formula and leaves a value of 100 and my formula is missing. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |