Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Help Creating Excel Formula

Hello All,

I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:

To explain I will use cells A1, A2, A3 & A4. To start cells A1 & A4 are
empty and cells A2 & A3 have values. Now when a value is added to cell A1 sum
cells A2 & A3 to cell A4. When the value in cell A1 increses add cell A3 to
the amount currently in cell A4 and so on (see below).

A1 A2 A3 A4
7200 600

A1 A2 A3 A4
1 7200 600 7800

A1 A2 A3 A4
2 7200 600 8400

A1 A2 A3 A4
3 7200 600 9000

I have been racking my head trying to figure this one out, so any and all
help is more then welcome and thanks in advance.


jamesvh
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Help Creating Excel Formula

Hi,

=IF(A1<"",B1+(C1*A1),"")

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"jamesvh" wrote:

Hello All,

I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:

To explain I will use cells A1, A2, A3 & A4. To start cells A1 & A4 are
empty and cells A2 & A3 have values. Now when a value is added to cell A1 sum
cells A2 & A3 to cell A4. When the value in cell A1 increses add cell A3 to
the amount currently in cell A4 and so on (see below).

A1 A2 A3 A4
7200 600

A1 A2 A3 A4
1 7200 600 7800

A1 A2 A3 A4
2 7200 600 8400

A1 A2 A3 A4
3 7200 600 9000

I have been racking my head trying to figure this one out, so any and all
help is more then welcome and thanks in advance.


jamesvh

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Help Creating Excel Formula

Try
=IF(A1,A2+(A3*A1),"")

--
Jacob (MVP - Excel)


"jamesvh" wrote:

Hello All,

I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:

To explain I will use cells A1, A2, A3 & A4. To start cells A1 & A4 are
empty and cells A2 & A3 have values. Now when a value is added to cell A1 sum
cells A2 & A3 to cell A4. When the value in cell A1 increses add cell A3 to
the amount currently in cell A4 and so on (see below).

A1 A2 A3 A4
7200 600

A1 A2 A3 A4
1 7200 600 7800

A1 A2 A3 A4
2 7200 600 8400

A1 A2 A3 A4
3 7200 600 9000

I have been racking my head trying to figure this one out, so any and all
help is more then welcome and thanks in advance.


jamesvh

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Help Creating Excel Formula

Mike & Jacob thanks for the help. Those formulas worked except for one thing.
The final amount in cell A4 is not persistent. I have a spin button that
advances cell A1 by 1 up to 18 then resets back to 1. When this happens the
amount in cell A4 resets also.

How can I get the cell A4 amount to be persistent with the formulas that
Mike & Jacob provided?

"jamesvh" wrote:

Hello All,

I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:

To explain I will use cells A1, A2, A3 & A4. To start cells A1 & A4 are
empty and cells A2 & A3 have values. Now when a value is added to cell A1 sum
cells A2 & A3 to cell A4. When the value in cell A1 increses add cell A3 to
the amount currently in cell A4 and so on (see below).

A1 A2 A3 A4
7200 600

A1 A2 A3 A4
1 7200 600 7800

A1 A2 A3 A4
2 7200 600 8400

A1 A2 A3 A4
3 7200 600 9000

I have been racking my head trying to figure this one out, so any and all
help is more then welcome and thanks in advance.


jamesvh

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Help Creating Excel Formula

Mike & Jacob thanks for the help. Those formulas worked except for one thing.
The final amount in cell A4 is not persistent. I have a spin button that
advances cell A1 by 1 up to 18 then resets back to 1. When this happens the
amount in cell A4 resets also.

How can I get the cell A4 amount to be persistent with the formulas that
Mike & Jacob provided?

"Jacob Skaria" wrote:

Try
=IF(A1,A2+(A3*A1),"")

--
Jacob (MVP - Excel)


"jamesvh" wrote:

Hello All,

I'm having a hard time creating a formula to collect data for work. Here is
what I'm looking to do:

To explain I will use cells A1, A2, A3 & A4. To start cells A1 & A4 are
empty and cells A2 & A3 have values. Now when a value is added to cell A1 sum
cells A2 & A3 to cell A4. When the value in cell A1 increses add cell A3 to
the amount currently in cell A4 and so on (see below).

A1 A2 A3 A4
7200 600

A1 A2 A3 A4
1 7200 600 7800

A1 A2 A3 A4
2 7200 600 8400

A1 A2 A3 A4
3 7200 600 9000

I have been racking my head trying to figure this one out, so any and all
help is more then welcome and thanks in advance.


jamesvh

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
Creating a formula in Excel Desperate Jae Excel Worksheet Functions 1 March 4th 10 04:10 PM
Creating formula in Excel Josh Excel Discussion (Misc queries) 4 December 24th 09 05:58 PM
creating formula in excel Andy J Excel Worksheet Functions 1 October 30th 09 02:14 PM
Need help on creating a formula in excel tbarrows Excel Worksheet Functions 2 July 25th 06 05:31 AM
Creating an Excel Formula clark1269 Excel Discussion (Misc queries) 1 July 24th 06 12:03 AM


All times are GMT +1. The time now is 05:37 PM.

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"