Table Formulas inside Pages

Discussion in 'Mac Apps and Mac App Store' started by Sparced, Aug 12, 2014.

  1. Sparced macrumors regular

    Sparced

    Joined:
    Nov 15, 2007
    Location:
    Liverpool, UK
    #1
    [​IMG]

    Can anyone help me using the formulas with please.

    l want to do is show I'm deducting a 25% discount after the discount.

    I'm really puzzled using it. That £ in B3 won't disappear either. :mad:
     
  2. Merode macrumors 6502

    Merode

    Joined:
    Nov 5, 2013
    Location:
    Warszawa, Poland
  3. liya1201 macrumors member

    Joined:
    Sep 8, 2010
  4. Merode macrumors 6502

    Merode

    Joined:
    Nov 5, 2013
    Location:
    Warszawa, Poland
    #4
    It'll also work but it's static formula. If you change discount in the C7 field, value after discount won't update.
     
  5. LV426 macrumors 6502a

    Joined:
    Jan 22, 2013
    #5
    B3 is formatted to display as a currency.

    Select the cell. In the Format flyout, select Cell. Then choose Number from the Data Format dropdown.
     
  6. liya1201 macrumors member

    Joined:
    Sep 8, 2010
    #6
    Merode is correct. Actually, the original formula was correct except missing a ")" after C7.
     

Share This Page