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
|