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