![]() |
Is there a way
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 |
Is there a way
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 |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com