| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
I need help with an excel formula. I put in the formula =A1*.25. When I type
100 in the A1 block it removes the formula and leave the number 100, when it should calculate 75. Am I doing something wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas
Put that formula in Cell B1 and then add 100 to cell A1. Now in Cell A1 you
will have 100 and in Cell B1 you will have 25. I am not too sure where you get the 75 from so if I am missing something just let me know... -- HTH... Jim Thomlinson "Chrissy" wrote: I need help with an excel formula. I put in the formula =A1*.25. When I type 100 in the A1 block it removes the formula and leave the number 100, when it should calculate 75. Am I doing something wrong? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas
Jim,
Thanks....cell B1 is A1*.75, to get 75% off A1 value!! it works.... Thanks Chrissy "Jim Thomlinson" wrote: Put that formula in Cell B1 and then add 100 to cell A1. Now in Cell A1 you will have 100 and in Cell B1 you will have 25. I am not too sure where you get the 75 from so if I am missing something just let me know... -- HTH... Jim Thomlinson "Chrissy" wrote: I need help with an excel formula. I put in the formula =A1*.25. When I type 100 in the A1 block it removes the formula and leave the number 100, when it should calculate 75. Am I doing something wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
Hybrid Mode
