| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Excel Idiot Needs Formula Help!! | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Hybrid Mode
