Excel Formula Help

[Griffin96]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Quantity[/TD]
[TD]Quantity sent[/TD]
[TD] [/TD]
[TD]Quantity left[/TD]
[/TR]
[TR]
[TD]Bai Mu Dan[/TD]
[TD]450KG[/TD]
[TD]120[/TD]
[TD]Calculation Formula in this cell[/TD]
[TD]Output calculation in this cell[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hi,

Im wondering from what i have shown in the tabel above is possible. I want a calculation formula in cell D2 but want the output in cell E2

Thanks
Luke

 

[TheRobRush]

can you possibly tell us why you want the calculation and output in different cells? Could help us give you best suggestion to resolve your problem.

easiest way would have your calculation in column D, hide it, then have column E be = D*

though I am not sure why you would separate them, so a reason why would help.

to have only value, no formula in E it would be better to use vba, but then you don't need column d formula either.

So I think we need more info.

 

[Michael M]

Also, it appears your quantity is a string not a number ??
Is this always going to be the case AND will the number value in that cell always be 3 digits, more / less ??

 

[Griffin96]

Hi, the reason why i want no formula in cell E is because im using macro's to copy the "quantity left" column and cut and past it in the "quantity in stock"
on my excel sheet all cells that contain numbers are set to show as KG. it the way my customer wants it all set out, so to make life easier i was using macros to cut the "quantity left" and past it in "quantity in stock"

 

[TheRobRush]

Yah you should probably do all this in VBA since the no formula in Column E is a necessity.

Just have it loop though each row and calculate/update column E, until it reaches a blank row in column A

after that just assign it to a button or a worksheet event.

Much harder for a client to accidentally break your vba than formulas anyways so its win win