Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Hello,
Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
=IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95))
Dave -- Brevity is the soul of wit. "Eamon" wrote: Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Dave,
Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
What error are you getting?
-- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Dave,
When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon "Dave F" wrote in message ... What error are you getting? -- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Your parentheses don't match, & the error being highlighted is that you
don't have enough arguments for the first IF statement. To cure that, try =IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) or =IF(O11<0,O11,IF(O11="","",Q10+O11*95%)) But that may not be what you want. If you're trying to produce a cumulative total, you may want something more like =IF(O11<0,Q10+O11,IF(O11="",Q10,Q10+O11*95%)) -- David Biddulph "Eamon" wrote in message ... Dave, When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon "Dave F" wrote in message ... What error are you getting? -- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Re the error only, it looks like the if got "closed" early. Try this:
=IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) -- Kevin Vaughn "Eamon" wrote: Dave, When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon "Dave F" wrote in message ... What error are you getting? -- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
David,
Just tried =IF(O11<0,Q10+O11,IF(O11="",Q10,Q10+O11*95%)) and works perfect many thanks. Thanks to David F as well. Your efforts are much appreciated. Thanks again. Best regards, Eamon "David Biddulph" wrote in message ... Your parentheses don't match, & the error being highlighted is that you don't have enough arguments for the first IF statement. To cure that, try =IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) or =IF(O11<0,O11,IF(O11="","",Q10+O11*95%)) But that may not be what you want. If you're trying to produce a cumulative total, you may want something more like =IF(O11<0,Q10+O11,IF(O11="",Q10,Q10+O11*95%)) -- David Biddulph "Eamon" wrote in message ... Dave, When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon "Dave F" wrote in message ... What error are you getting? -- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with negative number please
Kevin,
Thanks as well for your help, but have it solved with David's formula. Best regards, Eamon "Kevin Vaughn" wrote in message ... Re the error only, it looks like the if got "closed" early. Try this: =IF(O11<0,O11,IF(O11="","",Q10+(O11/100)*95)) -- Kevin Vaughn "Eamon" wrote: Dave, When I copy and past =IF(O11<0),O11,IF(O11="","",Q10+(O11/100)*95)) into Q11 I get the message the formula you typed contains an error and when I click OK "<0" the "0" is highlighted in black. Hope this helps. Eamon "Dave F" wrote in message ... What error are you getting? -- Brevity is the soul of wit. "Eamon" wrote: Dave, Thanks for your reply but am getting error in formula? Eamon "Eamon" wrote in message ... Hello, Appreciate any help please For example In O10:O1000 I have numbers such as... 56.50 100.00 -100.00 324.66 etc! In Q10 I have the number in O10 less 5% In Q11 I have =+IF(O11="","",Q10+O11/100*95) to keep a running total of the numbers in column "O" less 5% This is working fine until I come to a negative number in column "O" i.e. -100.00, when the number is negative I don't want to deduct 5%, how can I change the formula to do this please. Regards, Eamon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
remove negative from number | Excel Worksheet Functions | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
MROUND on a negative number. | Excel Discussion (Misc queries) | |||
thousand separator as indian style for negative number | Excel Discussion (Misc queries) |