Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 789
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I write a formula in excel that will calculate time? stacy Excel Programming 1 February 15th 06 03:55 PM
write a formula to calculate age in yrs; 04/30/06 minus birthdate yancey04 Excel Worksheet Functions 8 January 28th 06 10:00 PM
How do I write an Excel formula to calculate my working time? GregJ Excel Worksheet Functions 3 December 27th 05 01:48 PM
How do I write the formula to calculate someones time worked deusy Excel Worksheet Functions 3 November 16th 05 08:49 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"