Here's a sample of the data:
USAGE CURRENT PRICE A B C D SAVINGS 936 0.1204 0.1050 0.2163 0.1120 0.1303
I need to find lowest price within A-D (MIN) and subtract it from the current price, then get a savings total by multiplying the usage amount to the total of the first calculation. Can someone help?? Total should come to $14.42
Bookmarks