View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tanya M Tanya M is offline
external usenet poster
 
Posts: 17
Default formula not calculating right

It's the order of operations...

your formula should be: =(A3-(A3*C3))*B3

"Marilyn" wrote:

Hello in excel 2002
list price Units Discount Price
100 2 10.00% 80.00
columns a b c d consecutively.
this the formula I have in column D =A3-(A3*C3)*B3 result should be
180.00 . I get 80.00 How do I correct the formula ?
thanks in advance