cell formulae giving negative result.
Hi,
I would like the result to be zero.
Thanks
Brian
"Toppers" wrote:
what do you want the result to be if C2 < 10?
"BrianC500" wrote:
Hi,
I'm using the calculation IF(C2=49.99,39.99*0.06,IF(C2<49.99(C2-10)*0.06))
How can I stop achieving a negative result when I put a figure of less than
10 in C2?
Any help very much appreciated
Brian
|