In say, C1: =A1*(1-B1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"onebraincell" wrote:
Hi I'm really stuck and not sure where I'm going wrong.
If I put £100 in A1 and I put 40% in B1 and I want to take 40% away from
£100 then I thought the formulas in c1 would be =A1-B1 but it doesn't seem to
work. so what can I do to show A1 minus 40%?
Its doing my head in and I'm probably doing something really stupid. Please
help.