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

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)

In C1:
=(A1-B1)/A1
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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