Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need help please.
What I would like to do is this I have 25.86 in one cell in the cells to the right I need to multiply this by 1 or 2. is there a way for me to type the one of the numbers in the cell and the correct total with apprear in the cell |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
You can't put a number into a cell, then have that same cell do a calculation without using a macro. To do it with worksheet functions, you will need to use 2 cells. EG: If 25.86 is in cell B2, enter your multiplier (1 or 2) into cell C2 and enter =B2*C2 into D2. the answer will be in D2. Regards - Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|