View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swell estimator[_2_] swell estimator[_2_] is offline
external usenet poster
 
Posts: 13
Default want negative product not positive

the product of this formula =CEILING(E14/(C14/12),1) is 12 when the factors
are negative numbers (E14 is -15 and C14 is -16)

But I want the product to be a negative number -12 not 12

Any help out there? Thank you