Thread: Excel Formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SIR Knight SIR Knight is offline
external usenet poster
 
Posts: 27
Default 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