Check cells in row for last cell with data to use as multiplier?

Newsgal

Guest

Posts: n/a

12th Feb 2008

Week 1 Week 2 Week 3 Week 4 Week 5
B5 C5 D5 E5 F5 G5
H5
$26,665 100.0% 91.1% 0 0 0 $24,292

We have a spreadsheet that gets updated with new data each week. This
new data needs to become the new multiplier in the formula.
So, in the example above, I need a formula that reviews cells C5-G5 and
finds the first cell with a number > zero and uses it to multiply the value
in B5 and insert the result in H5. Any ideas?
--
News Gal

« For Each ws autofill | return chart's source data location/range »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
when i use =product(cell,multiplier), the box ... only shows ###	gogh	Microsoft Excel Misc	1	24th Jan 2008 02:57 AM
updating a range of cells by a multiplier	=?Utf-8?B?c3BlbmNl?=	Microsoft Excel Worksheet Functions	5	1st May 2007 10:13 PM
Check if a cell contains text compared to a range of cells	GD1226, Captain Ahab, manface	Microsoft Excel Misc	5	13th Apr 2007 01:00 AM
RE: How to check if a cell is part of a series of cells (not a neat ra	=?Utf-8?B?dGR3?=	Microsoft Excel Programming	0	21st Jun 2006 05:34 PM
Using a grouping of cells to check one cell against another...	=?Utf-8?B?ZGV1Y2Vy?=	Microsoft Excel Worksheet Functions	1	11th Jan 2005 04:19 PM