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