Posted to microsoft.public.excel.worksheet.functions

Carpe Diem Carpe Diem is offline

external usenet poster

Posts: 28

Formula to multiply numbers intervals

Hi all,

I need to arrange a formula to calculate the following :

< 80.000 < 150.000 150.000
a $0,460 $0,440 $0,400
b $0,120

A 175000
B 125000

I need for case A which is equal to 175.000:
A= 80000*.46+70.000*.44+25.000*.40

I tryed sumproduct but I could do it

Thanks in advance

Carpe

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
If between 2 numbers, multiply	Gee...	Excel Worksheet Functions	5	September 23rd 08 05:18 PM
placing numbers in one column at intervals of 2nd	[email protected]	Excel Discussion (Misc queries)	0	September 13th 06 06:01 AM
Excel should let me divide and multiply time intervals	b.garmon	Excel Worksheet Functions	2	July 24th 06 11:41 PM
multiply a row of numbers by %	jshgolf	Excel Worksheet Functions	2	March 13th 06 04:45 PM
Formula between to numbers is true multiply	pflynn	Excel Worksheet Functions	4	December 22nd 04 02:22 AM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us