Thread: cell formulae giving negative result.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrianC500 BrianC500 is offline
external usenet poster
  
Posts: 10
Default cell formulae giving negative result.
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
Reply With QuoteReply With Quote