Welcome to iPadForums.net Guest - Click Here to Register

Numbers question

This is a discussion on Numbers question within the iPad 2 Forum forums, part of the Apple iPad Discussions category; I am trying to create a spreadsheet where column "b" = possible sales and column "c" = captured sales and column "d" will = c/b ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    iPad Fan!
    Member #
    44213
    Join Date
    Apr 2011
    Location
    North Alabama
    Posts
    8

    Numbers question

    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. Ads


  3. #2
    iPF Legend
    Member #
    27654
    Liked
    119 times
    Join Date
    Jan 2011
    Location
    Scotland
    Posts
    15,248
    Quote Originally Posted by Sam4msu View Post
    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.
    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

  4. #3
    iPad Master!
    Member #
    545
    Liked
    1 times
    Join Date
    Feb 2010
    Posts
    340
    In cell D1, double tap to edit.

    Press the = button on the input bar.

    Tap cell B1 to put it in.
    Tap the (**** 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 by Dorje; 04-07-2011 at 11:21 AM.
    Add 202 to my user number and call me an Airplane.

    --iPad 2 64 GB Black WiFi "Dynabook 2011. With know-how and integrity"

  5. #4
    iPad Fan!
    Member #
    44213
    Join Date
    Apr 2011
    Location
    North Alabama
    Posts
    8
    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.

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1546 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,470
    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.

  7. #6
    iPad Fan!
    Member #
    44213
    Join Date
    Apr 2011
    Location
    North Alabama
    Posts
    8
    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.

  8. #7
    iPF Legend
    Member #
    28530
    Liked
    1546 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,470
    Here is Apple's iWorks for iPad help site. Also check out the Help site on the iPad. It's under the wrench menu when a document is open.

    http://help.apple.com/iwork/1.3/safari/#tan7248917d


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Numbers app
    By robertmorgan480 in forum iPad Apps
    Replies: 1
    Last Post: 03-20-2011, 04:24 PM
  2. Numbers
    By jimdd in forum iPad Apps
    Replies: 1
    Last Post: 02-07-2011, 01:18 AM
  3. New to numbers
    By Blarto35 in forum iWork Forum
    Replies: 0
    Last Post: 10-17-2010, 10:59 PM
  4. Numbers
    By Sincere11105 in forum iWork Forum
    Replies: 5
    Last Post: 08-21-2010, 08:06 AM
  5. Numbers question. can it be done?
    By comtechs in forum iWork Forum
    Replies: 0
    Last Post: 06-28-2010, 11:47 PM

Search tags for this page

how do you access ipad numbers input bar
,

how to do percentages in numbers app

,

how to make a check mark symbol on the ipad

,
ipad numbers done tab
,

iwork numbers formula percentage

,

numbers ipad cell reference

,
numbers tutoriial
,
percentage in iwork
Click on a term to search for related topics.