Thread: percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default percentage

percent change expression: to/fm%-100

may need to figure out the order you want it in.. if need to subtract
damaged items from 1 of the items.

=(A1-B1)/C1%-100




"Zul" wrote:

goods received (A1) 35 Damaged goods (B1) 2 how do i get the percentage for
the goods received without damages in (C1)