Fellow ExcelERs,
I am trying to write a formula whereby if a certain value is selected in a cell from a dropdown list it is then looked up in an array table and there will be a value (%) in index column 2 and a calculation is performed base on it being multiplied by the value of another cell. However if a lookup value needs to have a return value of <=1 (max £1.00) then how can I incorporate this into the formula.
A lookup calculation of a certain value maybe £1.25 but I would like the value returned to be £1.00. If the same lookup value calculation generates a value of £0.75 then this will remain as the value.
What I am trying to achieve is an accounting spreadsheet where certain costs where selling promotions are applied a MAX selling fee regardless of the actual selling fee will be applied.
Many thanks on any thoughts.
Rahul
I am trying to write a formula whereby if a certain value is selected in a cell from a dropdown list it is then looked up in an array table and there will be a value (%) in index column 2 and a calculation is performed base on it being multiplied by the value of another cell. However if a lookup value needs to have a return value of <=1 (max £1.00) then how can I incorporate this into the formula.
A lookup calculation of a certain value maybe £1.25 but I would like the value returned to be £1.00. If the same lookup value calculation generates a value of £0.75 then this will remain as the value.
What I am trying to achieve is an accounting spreadsheet where certain costs where selling promotions are applied a MAX selling fee regardless of the actual selling fee will be applied.
Many thanks on any thoughts.
Rahul