I am really not good at Excel and am battling to finish my formula. I apologise in advance if this has been answered before but I can't fidn the right formula.
The first part of my formula works really well. It basically looksup a Trade Discount percentage (from a named table) and delivers to the right cell, however, I want to be able to show a blank cell in both Price increase and Trade Discount if there is no cost price entered.
Apparently Vlookup only looks right and this field happens to be on the left. I tried to add the LEN & IF & SumIfs but can't get any of them right.
<tbody>
</tbody>
The first part of my formula works really well. It basically looksup a Trade Discount percentage (from a named table) and delivers to the right cell, however, I want to be able to show a blank cell in both Price increase and Trade Discount if there is no cost price entered.
Apparently Vlookup only looks right and this field happens to be on the left. I tried to add the LEN & IF & SumIfs but can't get any of them right.
COST PRICE | PRICE INCREASE 2017 | TRADE DISCOUNT | INSTALLATION COSTS | TOTAL COST PER BLIND | |
=IFERROR(VLOOKUP($T$3,suppliers,2,0),"") | =IFERROR(VLOOKUP($T$3,suppliers,3,0),"") | =IFERROR(VLOOKUP($F12,$Y$13:$AC$27,4,0),"") |
<colgroup><col width="96"></colgroup><tbody> </tbody> | ||
This is entered manually | This looks at a field where I select a supplier from drop down list and the associated price increase from supplier | This looks at a field where I select a supplier from drop down list and the associated trade discount from supplier | This looks at a field where I select a product from drop down list and the associated installation cost is input | This works out the total COST price of the blind. | |
I now want to add a formula that if the cell to the left "Cost price" is blank, then this field remains blank. However, the minute I input the supplier in the drop down cell, it automatically puts in the percent increase. Even though I have added the Iferror formula??? | I now want to add a formula that if the cell to the left "Cost price" is blank, then this field remains blank. However, the minute I input the supplier in the drop down cell, it automatically puts in the trade discount. | This formula works fine. | This formula works fine. |
<tbody>
</tbody>