ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hw to write a macro to calculate values (https://www.excelbanter.com/excel-programming/379161-hw-write-macro-calculate-values.html)

Akash

Hw to write a macro to calculate values
 
I want the following workflow module:

A + B - C = D

A B C D
10 10 05 = 15
20 20 10 = 30
40 60 00 = 100

What would be the Code


Martin Fishlock

Hw to write a macro to calculate values
 
Akash,

What are you trying to do?

I don't see why you need code for the specified formula of a+b-c.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Akash" wrote:

I want the following workflow module:

A + B - C = D

A B C D
10 10 05 = 15
20 20 10 = 30
40 60 00 = 100

What would be the Code



[email protected]

Hw to write a macro to calculate values
 
Hi
I can't believe any reader would have any idea what you want here. The
only thing I can think of is that in column D, row 1, you want the
formula

=A1+B1-C1

and copy down for the other rows.

regards
Paul

Akash wrote:

I want the following workflow module:

A + B - C = D

A B C D
10 10 05 = 15
20 20 10 = 30
40 60 00 = 100

What would be the Code



Akash

Hw to write a macro to calculate values
 
Dear Paul,

I want the Macros... Not the simple way =A1+B1-C1

I dont know how to write a macros. So thts y i asked u a sime thing to
write a simple macro, so that i could make ammendments and try to use
the same macro for Division, Multiplication, Average, Countif and more
.....

Awaiting for ur reply...

Regards

Akash

On Dec 11, 2:05 pm, wrote:
Hi
I can't believe any reader would have any idea what you want here. The
only thing I can think of is that in column D, row 1, you want the
formula

=A1+B1-C1

and copy down for the other rows.

regards
Paul

Akash wrote:
I want the following workflow module:


A + B - C = D


A B C D
10 10 05 = 15
20 20 10 = 30
40 60 00 = 100


What would be the Code




All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com