Blackspear
New Member
- Joined
- Apr 26, 2002
- Messages
- 30
Last week I sold $110 (A1), this week I sold $77 (B1) the percentage increase/decrease (C1) is -30%, what formula do I need to place in C1?
On 2002-04-27 04:00, Blackspear wrote:
Thanks for your reply, that doesn't work, it gives 43%, were the answer is a decrease of -30% in sales, $110 last week, this week down by 30% to $77
On 2002-04-27 04:44, Blackspear wrote:
My appologies Aladin, I don't know what I did, but your formula works, thank you very much. I have one more question for you. I am calculating 100/10 = 10, if 100/0 = 0, how do I get it to display "0" rather than the error code "Num/0!" ???