Thread: discount formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default discount formula
=A2-A2*A3

OR

=A2*(1-A3)

--
Jacob


"Ayman" wrote:

if A2=500 A3 20% discount A4 net amount what the formula is ?for A4
Reply With QuoteReply With Quote