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
|