Excel Formulas
pippawl,
Assumptions:
Column A = entry of 15, 10 and 5
Column B = Value of the vaoucher
You can use an IF formula
=IF($A1=15,200,IF($A1=10,150,IF($A1=5,100,"")))
This will give you your value of voucher depending on what is entered
in column A
Hope this Helps
Steve
|