Numbers question

Discussion in 'iPad 2 Forum' started by Sam4msu, Apr 7, 2011.

  1. Sam4msu

    Sam4msu iPF Noob

    Joined:
    Apr 6, 2011
    Messages:
    8
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    North Alabama
    Ratings:
    +0 / 0
    I am trying to create a spreadsheet where column "b" = possible sales and column "c" = captured sales and column "d" will = c/b in a percentage or close rate. I know that in excel the formula is d1=c1/b1 but I cannot get my numbers app to total this for me. Can anyone please help me with formatting this cell to represent a percentage.
    Thanks for any help you can offer.
     
  2. Tim SPRACKLEN

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,236
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 1
    One of our most prolific posters - who has the answer to everything - twerppoent - I'm sure will be able to answer this - he's on the West Coast (of the US!)..so still asleep...perhaps...welcome...

    Tim
    Sunny (at the moment) Scotland
     
  3. Dorje

    Dorje iPad Enthusiast

    Joined:
    Feb 7, 2010
    Messages:
    340
    Thanks Received:
    1
    Trophy Points:
    0
    Ratings:
    +1 / 0
    In cell D1, double tap to edit.

    Press the = button on the input bar.

    Tap cell B1 to put it in.
    Tap the (fuck cant actually find the divide character in the iPad keyboard)
    Tap cell C1
    Press the green check mark

    To fill down, one tap and hold on D1 then select Fill.
    Drag the yellow bar down as far as you want.

    Hope that helps. I'm just staring in on iPad Numbers myself and the fact that I could not manual type cell references threw me. Personally I'm not sure I'm happy with that. Guess I'm kinda old in my ways. Although I can see how in a tap interface just tapping would be almost as easy... What with no mouse movements.

    If you really are an old-school formula guy like me perhaps DocumentsToGo may be more to your liking.
     
    Last edited: Apr 7, 2011
  4. Sam4msu

    Sam4msu iPF Noob

    Joined:
    Apr 6, 2011
    Messages:
    8
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    North Alabama
    Ratings:
    +0 / 0
    Well, that was easy!!! My only other question is how do I make it represent a percentage?? If b=10 and c=5 I would like d to=50%.
    thanks again.
     
  5. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,244
    Thanks Received:
    2,460
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,003 / 1
    To format a cell to display percentages.

    Tap on the cell to select it. Tap on the info icon (the i in a circle icon top right) and choose Format tab. Choose Percentage from the list and pick the options you want.

    Or if you want a really simple but not pretty solution, change your formula to =(c/b)x100.
     
  6. Sam4msu

    Sam4msu iPF Noob

    Joined:
    Apr 6, 2011
    Messages:
    8
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    North Alabama
    Ratings:
    +0 / 0
    Awesome...Thanks for the great tips. Is there anywhere online that has a good tutorial for Numbers, Pages and Keynote? I hate to always post my questions here.
     
  7. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,244
    Thanks Received:
    2,460
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,003 / 1

Share This Page

Search tags for this page
app numbers percentage format on ipad
,
can you add a column of check marks in apples numbers
,
how to calculate percentages in iworks numbers
,
how to count percentage in ipad numbers
,

how to do percentages in numbers app

,
ipad numbers percentage
,
numbers ipad get total of column
,
percentage formula for numbers on ipad
,
percentage in numbers on ipad
,
tick symbol