Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |