Straight forward idiot question!!!
 

Hi, i'm trying to return a value in Q2 as in the equation below but the
cell P2 is formatted as percentage and i want the value in Q2 to show
the sum of E2:O2 minus the percentage in P2. Im sure this one is a no
brainer for you guys......just cant seem to get my head round it, the
equation below gives me the percentage total in Q2 not the whole total
minus the percentage.

=SUM(E2:O2)*(-P2)

Al help or suggestions welcome!

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=470733

=SUM(E2:O2)*(1-P2)

So if P2 contained 40%, you'd end up with 60%*sum(e2:o2).



Simon Lloyd wrote:

Hi, i'm trying to return a value in Q2 as in the equation below but the
cell P2 is formatted as percentage and i want the value in Q2 to show
the sum of E2:O2 minus the percentage in P2. Im sure this one is a no
brainer for you guys......just cant seem to get my head round it, the
equation below gives me the percentage total in Q2 not the whole total
minus the percentage.

=SUM(E2:O2)*(-P2)

Al help or suggestions welcome!

Simon

--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=470733

--

Dave Peterson

Cheers Dave,

I just couldnt see the wood for the trees!

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=470733