Numbers question

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

  1. Sam4msu
    Offline

    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
    Offline

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,246
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 0
    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
    Offline

    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
    Offline

    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
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,412
    Thanks Received:
    2,036
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,322 / 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
    Offline

    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
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,412
    Thanks Received:
    2,036
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,322 / 1

Share This Page

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

how to do percentages in numbers app

,
how to find percentage in numbers ipad
,
how to use numbers to add a check mark column on a spreadsheet on ipad
,
ipad numbers done tab
,
ipad numbers percentage
,
manually type cell in numbers ipad
,
numbers ipad get total of column
,
numbers tutoriial
,
percentage formula for numbers on ipad
,
percentage in numbers on ipad
,
percentages iwork numbers
,
reference in ipad numbers
,
tick symbol