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
|