12 May 2008 at 08:54 #1 Ish Ish Associate Joined 11 Jan 2006 Posts 1,815 Location West Midlands Hi Can someone help me with this formula please. I need a formula which does this:- If A1=£100 to £199 then B2 should = A1 minus 35% and if A1=£200+ then B2 should = A1 minus 40%. Thanks
Hi Can someone help me with this formula please. I need a formula which does this:- If A1=£100 to £199 then B2 should = A1 minus 35% and if A1=£200+ then B2 should = A1 minus 40%. Thanks
12 May 2008 at 11:42 #4 Ish Ish Associate OP Joined 11 Jan 2006 Posts 1,815 Location West Midlands Thanks guys yes the formulas do need to work with money figures. i will test them out later.
