Since B1 contains the percentage to be taken away, hence the remaining
percentage will be: 1-B1 (this is the same as writing: 100%-B1)
The remaining value to be calculated is hence: A1 x (1-B1) or: =A1*(1-B1)

Take a moment to press the "Yes" button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"onebraincell" wrote:
Thank you so much but could you explain why that formula. Sorry would just
like to know how in future.
Many many thanks