Discount for Members Question

  • Thread starter Thread starter stevo
  • Start date Start date
S

stevo

I am using excel as a booking sheet and I would like to set it up s
that people who are members get a 10% discount. I'd like to know i
it's possible to automatically deduct 10% from their payment dependin
on wether or not the membership collum was set to yes or no?

i.e.
Collum A asks if they're a member
Collum B is what they paid for the event

I know I can add a third collum to give the price less discount but i
it possible just to automate it with just the two?

Many thanks
St
 
Hi

It's not possible to have a value and a formula in a single cell. You could
get round this problem with VBA, though. In the third column (Total Due) you
could use:
=IF(A2="Y",B2*0.9,B2)
 
Back
Top