|
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? |
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? |
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? |
| All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com