17 Dec 2009 at 11:19 #1 Guest2 Guest2 Soldato Joined 6 May 2009 Posts 20,379 I have a figure 89,934 in cell D35, below in a cell is the formula =D35/2-9600 which gives 35,967. How then, do i find 18% of 35,967? Thanks
I have a figure 89,934 in cell D35, below in a cell is the formula =D35/2-9600 which gives 35,967. How then, do i find 18% of 35,967? Thanks
17 Dec 2009 at 11:20 #3 Majago Majago Soldato Joined 5 Feb 2004 Posts 3,411 Location Stroud =35967*0.18 or =D36*0.18 or if you want it all in 1 cell, in D36 type =(D35/2-9600)*0.18
17 Dec 2009 at 11:22 #4 Guest2 Guest2 Soldato OP Joined 6 May 2009 Posts 20,379 thanks edit - i tried the *0.18 but forgot the brackets Last edited: 17 Dec 2009