Straight forward idiot question!!!

[Simon Lloyd]

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

 

[Dave Peterson]

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

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

 

[Simon Lloyd]

Cheers Dave,

I just couldnt see the wood for the trees!

Regards,

Simon