LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 148
Default Help on a formula

Columns A, B, and C are prices. Column D is the number of each object I
need. I want to take the least expensive in each row and multiply it by D.
However, the least in A, B, and C cannot be 0.00. In the end, it will cost
to but these objects.

I've tried =$D1*(MIN(IF($A1:$C1<0,$A1:$C1,Z52))) just for the 1st row, and
it gives me a Value error at the 1st $A1:$C1.

Any ideas on how to get the total?

A B C D

0.04 0.07 0.05 10
0.17 0.83 0.22
1.36 0.79 0.04 1
0.82 0.69 0.70
1.97 1.32 1.31 1
0.20 1.68 1.49 1
2.84 2.57 3.16
2.84 2.57 3.16 2
0.00 2.57 0.00
0.88 1.92 2.10
1.74 0.51 0.22
2.24 1.83 2.46
0.05 0.83 0.08
0.47 0.68 0.18
0.47 0.68 0.43
3.97 4.19 2.62
0.86 0.71 0.51
0.97 0.23 0.32
0.84 0.72 1.30


 
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



All times are GMT +1. The time now is 10:15 PM.

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

About Us

"It's about Microsoft Excel"